How do I reference a Range Based on Variable?

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
i think you can't just put one quote
maybe do chr(34) or whatever the ascii for quotation mark is
 
Back
Top