Syntax Error on range selection

XLS Padlock
1

Hi
I am trying to compile my code and i am getting a syntax error on this section

‘’’’ Put Labels in Col A + B
Range(“A4”).Value = “Customer”
Range(“B4”).Value = “Invoice Details”

Code above this is accepted but nothing below seems to be accepted.

Please let me know why it is not working all the way through the code.
Thanks

2

Try instead:
**Application.**Range(“A4”).Value = “Customer”
**Application.**Range(“B4”).Value = “Invoice Details”

All Excel objects can be accessed if you prefix them with Application. It’s explained in the user guide of XLS Padlock.