Run time error ‘1004’

[mdavid800]

Hi there was wondering if anybody could help I have this code which I am trying to set up so as depending on the month the rest of the code will use a different sheet. My sheets are called TPM1, TPM2 and so on up to TPM 12. the code below for instance works fine but It is fixed on TPM10.

Please Login or Register  to view this content.

therefore I changed this to read.

Please Login or Register  to view this content.

where iMonth is the number of month located in cell E4 and set as integer but for this I get a

Run time error ‘1004’: Method “Range of object_Global failed error

Can anybody help me/ tell me how to do what I want to. I am new to this and Visual basic for dummies isn’t much use.

Cheers David

[Colin Legg]

Hi David,

Your code is missing the closing ' around the sheet name and an exclamation mark:

Please Login or Register  to view this content.

In VBA, it is better to use & to concatenate strings rather than +.

Also, rather than using syntax like this:

Please Login or Register  to view this content.

It is better to use this:

Please Login or Register  to view this content.

So, taking into account the above suggestions, your code would then become:

Please Login or Register  to view this content.

[mdavid800]

Thank you Colin

worked like a charm

also thanks for the advise on correct syntax etc as i said im new to this and am trying to learn of some other examples and was picking up other peoples bad habits

once again thanks

David