Link to home
Create AccountLog in
Avatar of creativefusion
creativefusionFlag for Australia

asked on

Excel VBA Syntax

Hi All,

I have a question regarding syntax on a line of code that is currently giving me an error.

Please note, I am new to Excel VBA and have the "Require Variable Declaration" option selected thus Option Explicit.

I have enclosed the line of code that is bugging with "Syntax Error"

Any help?
Range("ExportData & "!A1").PasteSpecial xlPasteAll

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of creativefusion

ASKER

Thanks