Adding constant values using object variable coding

Hi, I'm tying to add some values to a worksheet - some are picked off another worksheet and some are constants e.g. G The code below goes into error when trying to add the constants. Can you tell me what is the correct syntax to use to be able to add these constant values? thanks, Neil

Please Login or Register  to view this content.

I'm just curious: in lines with errors shouldn't be WSD1 instead of WDS1?

You're right - clearly getting tired and need to stop! thanks, Neil

What I can recommend to you is to go to VBA editor, click Tools -> Options and in Editor tab tick Require Variable Declaration. This should prevent you from using undeclared variables (note after that operation an Option Explicit code line will be added every time you make new macro).