Copying Cells with Macros

[(AQ)AQuayum]

Hi there guys,

This is my first post on Chandoo, so any sort of help will appreciate it a lot.

Am trying to record a simple Macro, which will select all the data and just copy it without pasting it anywhere. (planning to paste it manually on another sheet)

The problem is, when am adding new data, the new rows are not selected. It's only selecting and copying (dotted lines around the data) the old data, and everytime new data is inserted it doesn't select them at all.

I've tried using relative references along with absolute reference with the Macro option, however still not working. Would appreciate any help on this.

I've attached a picture as well.

 

[Marc L]

Hi !

Must see in VBA inner help like in threads of this forum :

CurrentRegion & UsedRange …
​

 

[(AQ)AQuayum]

Hi Marc,

Am not quite sure what you mean, would appreciate the further clarity.

Thanks

 

[Marc L]

Difficult to be clearer than the VBA inner help and its examples
so just read it and try …​