Excel macro to select and copy

Closed

PM - Mar 25, 2010 at 04:37 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 25, 2010 at 04:48 AM

Hi,

I would like to how the code to write a macro that can select/copy the last entry in a column/s.

Thanks in advance

PM

Excel 2003

Excel macro to select and copy
Excel date format dd.mm.yyyy - Guide
Vba select case like - Guide
Transfer data from one excel worksheet to another automatically - Guide
Spell number in excel without macro - Guide
Macro excel download - Download - Spreadsheets

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 25, 2010 at 04:48 AM

cells(rows.count,"A").end(xlup).select

selection.copy

Subscribe To Our Newsletter!