required pasteing

  • Thread starter Thread starter Noctos
  • Start date Start date
N

Noctos

could i create a macro which would collect information from fixed cells
everytime it was initiated and the when it came tp paste th information
say in b1 it would move down a cell and paste the info each time the
macro was initiated
 
Yes, smething like the following.

Sub MyPaste()
set data= Range("G24") 'the fixed cell
dest = application.worksheetfunction.counta(range("B:B")+1
dest =data

End Sub

Not tested

Regards
Peter
 
Back
Top