If I have a named range, rng, that encompasses cells A30 to O35 and to add a row at the beginning (row 35) using a Macro then rng shifts down as well so that it is now A31:O36.
How can I add a row in VBA and then expand rng to include the new row so that it is now A30:O36?
I've been searching but so far haven't been able to get either Resize or Offset to work to accomplish this.
Thanks in advance.
Hi
try this
Please Login or Register to view this content.
I think I misread you request - these do not include inserting a row
What you are trying explained:
Simplified:Please Login or Register to view this content.
As a single line:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by kev_; 04-12-2017 at 01:08 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
This time includes adding a row at the top (which makes Excel push the named range down by a row)
(With Named Range "MyNamedRange" with RefersTo = A30 to O35)
(after VBA run, NamedRange "MyNamedRange" with RefersTo = A30 to O36)Please Login or Register to view this content.
Last edited by kev_; 04-12-2017 at 02:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks