MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VISUAL Basic i guess copy+paste


Posted by Jonny D on December 29, 2001 2:26 PM

I have a report that need to have two cloums last data paste over to another sheet, but how can i find two rows if the will be different?

Data on Col A A34 = Design
Data on Col B B4 = Staff 6

so need to return these but tommorow the rows will cahnge as i add data so cold be A40 and B4 - Please help

Thanks


Posted by Jacob on December 29, 2001 3:45 PM

Hi

To get the last data try this

range("A65536").end(xlup).select
and
range("B65536").end(xlup).select

Jacob

Posted by Jonny D on December 30, 2001 3:05 AM

jacob so simple ill try thanks