Do Until Macro

B

Beep Beep

I have over 500 Excel Files that I need to import into Access, however I want
to get them cleaned up first. One of the things I would like to is run is a
macro from lets say cell J- 7000 ( this could vary with each individual
file) and what I am thinking of is that I would input the store number of
like 0001 into this field and then the macro would copy it up until it got to
the column header which would say store and then stop.
 
D

dbKemp

I have over 500 Excel Files that I need to import into Access, however I want
to get them cleaned up first. One of the things I would like to is run is a
macro from lets say cell J- 7000 ( this could vary with each individual
file) and what I am thinking of is that I would input the store number of
like 0001 into this field and then the macro would copy it up until it got to
the column header which would say store and then stop.
Click to expand...

Dim rStoreNo As Excel.Range

Set rStoreNo = Range("J2:J7000")
rStoreNo.Value = "'0001"
 
Top