LinkBack URL
About LinkBacks
I would like a range of cells to equal an active row range of cells. I am trying but what i have below wont work, can someone point out the error in the code below?
Please Login or Register to view this content.
I would like a range of cells to equal an active row range of cells. I am trying but what i have below wont work, can someone point out the error in the code below?
Please Login or Register to view this content.
Maybe (untested):
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
So are you trying to copy from z53:z58 to AE:AJ of the active row or are you trying to get active TO z53:z58?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thank you for responding.I would like active to equal "Z53:Z58"....I havent yet tested TMS suggestion, however i would like the entire active range :"AE,AF,AG,AH,AI,AJ" ("AE:AJ") to be placed in Range "Z53:Z58"
FWIW:
Please Login or Register to view this content.
If we're playing with alternatives ...
Please Login or Register to view this content.
or even:
Please Login or Register to view this content.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks