Call function not working

**abz** · 07-19-2010, 06:40 PM

Hi guys i am trying to call a macro which i have recorded in a spreadsheet, dont know what is happening to it but it seems to be giving me an error. I am using a simple comand buttone to call 2 macros, one of them is working perfectly but the other one is giving me an error. below is the code:

Please Login or Register  to view this content.

On clicking this button vba gives me a compile error, saying 'Expected variable or procedure,not module'.

However if i omit this one and just have the second macro it works fine.
I have tried moving this to other places in the worksheet to trigger it but everywhere it is giving me an error. Thus im guessing it might be an error with the macro itself which is as below:

Please Login or Register  to view this content.

Could you guys have a look at this and let me know what is going wrong here, i was working on this a couple of hours ago and both the macros were working fine, no problems at all, dont know why its doing this now.

Regards,
Abz

**TMS** · 07-19-2010, 06:46 PM

When you are coding inside a WITH statement, you need to precede the RANGEs with a full stop / period.

You don't do this consistently.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

and check the rest of the RANGEs and CELLS, etc

Regards

**abz** · 07-19-2010, 06:53 PM

Tried all that, still no resolution, the thing is if i run the macro completely separately, it works fine again, no problems.

Its just not calling that particular macro and its thinking of it as something other than a call statement.

**TMS** · 07-19-2010, 06:57 PM

Post the corrected code and/or a sample workbook

Regards

**abz** · 07-19-2010, 07:16 PM

Guys,

Problem just been solved, i had changed the name of the module in the properties pane on the left, i changed it back to Module 1 and its working again as usual.

Regards,
Abz