Hello,
In one of my worksheets, I have a range called “Summary” .
I want a code which would insert a new Entire.Row into the “Summary” range.
When the inserting takes place, my ActiveSheet is not the one which has the “Summary” and I want to achieve this by not having to activate that sheet.
Could you please advise?
Thanks
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
mehmetcik,
it is almost there...
Te code is inserting a row in the "Target" but what I need, is to insert a row in a range called "Summary" which is in the "Target" worksheet.
Thanks in advance!
This code will create an array:
SR(1) will give you the start columnPlease Login or Register to view this content.
SR(2) will give you the start row
SR(3) will give you the End column
SR(4) will give you the End row
So calculate the row you want to insert at and use the first code to insert there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks