EZ: Autofill with a variable

[yeoman12]

This should be an easy one for someone...

I've managed to cobble together some code that does nearly everything I need, except for one lousy thing...
I need to add a new field in (S1) lets say FileNm and I need to populate that field from the first record to the last in my file.

I have looked at something like this...
Selection.AutoFill Destination:=Range("S2:S" & LastRow), Type:=xlFillDefault
or this
Range("S2").AutoFill Destination:=Range("S2:S" & LastRow, "File01")

Where LastRow is a variable I have defined earlier in the code as
LastRow = Range("J2").End(xlDown).Row

The problem is that instead of using a Type I'd really just like to call the value of another String variable I have defined earlier in my script, called File01 as I tried in the second example above.

This seems like something that should be pretty easy to do, I just cannot figure it out!
Thanks in advance.

 

[ukmikeb]

Hi

Try -

Range("S1:S" & LastRow).Filldown

Note the use of cell S1 which contains your file name.

hth

Mike

 

[Weaver]

I think this might be what you're after

Range("S2:S" & LastRow).value = "File01"

 

[yeoman12]

Thanks guys, I'm good to go!
Really appreciate the suggestions.