Dear friends,
Instead of static ActiveSheet.Range("$A$2:$E$1616") i want to select the active sheet as CTRL SHIFT END...?
How to accomplish this..?
Thanks,
Abhijeet.
Dear friends,
Instead of static ActiveSheet.Range("$A$2:$E$1616") i want to select the active sheet as CTRL SHIFT END...?
How to accomplish this..?
Thanks,
Abhijeet.
Why do you want to manually select the range? Or select it that way?
You can make the macro do it.
Here the copy command is given as an example.Please Login or Register to view this content.
You can change the Sheet1 to activesheet if you need.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Maybe another option.
Activesheet.UsedRange
HI
If the data always starts in A2 you could also do
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks