View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric_G Eric_G is offline
external usenet poster
 
Posts: 41
Default find last row in one column and copy + paste data to same row in a

I'm attempting to do the following in an excel macro:
Step 1: - find last row containing data in column X
Step 2: - copy the formula from cell Y1 through every cell down to Y* where
* represents the row number found in step 1

Can anybody help? Thanks.