Nearly got there!


Code
-------------------
'In main workbook, find which column to paste data into
Windows("Stores.xls").Activate
Sheets("Till0" & TillNumber).Select
Range("A1").Select

'Search for the Cap Date
Cells.Find(What:=CapDate, LookIn:=xlFormulas, SearchFormat:=False).Activate
Dim CapDateCol As Range
CapDateCol = ActiveCell.Colum
-------------------


The only thing i can't do is go to a certain cell to paste in my data.

I'm in the correct column after doing the search.

I just need to go down to a row named "Zero"

Any ideas?
Thanks

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=53452