How do I reference a Range Based on Variable?

[Dan]

Hi,

I want to paste a formula in xlSheet.Range("F4:F" & intMaxRow &
").PasteSpecial but I get an error. How can I reference the range with
intMaxRow variable?

TIA,
Dan

 

[john m]

i think you can't just put one quote
maybe do chr(34) or whatever the ascii for quotation mark is

 

[Alan Beban]

i think you can't just put one quote
maybe do chr(34) or whatever the ascii for quotation mark is

Try Range("F4:F" & intMaxRow)

Alan Beban

 

[Dan]

Try Range("F4:F" & intMaxRow)

Alan Beban

That did it. Muchos gracias, Dan