Run macro on this workbook

In the VBA editor type in either ThisWorkbook or ActiveWorkbook, leave the cursor somewhere in the word and press F1.

As you might expect

Please Login or Register  to view this content.

Returns the value from cell A1 of the first sheet of the workbook that holds the macro, whereas:

Please Login or Register  to view this content.

Returns cell A1 of the first sheet of the workbook that was active when the macro was called. While:

Please Login or Register  to view this content.

Gives you cell A1 of whichever sheet was active when you ran the macro.

I'd say that 99% of the macros I write use ThisWorkbook, ActiveWorkbook or ActiveSheet - they're very useful indeed.

Thanks Andrew-R, that gave me a good overview of these codelines (which I have had some problems understanding in the past)


Gnoke

I am trying to modify the code above.
Where schould I write "Msgbox ThisWorkbook.Sheets(1).Range("A1).Value" ?
Considering that the application is called 98 times, do I have to change this codelines for every call?:
'120810 printing.xls'!PrintPDF

Gnoke

If you get rid of the Application.Run bit and the file name and instead just put the line:

Please Login or Register  to view this content.

in your macro does that run any better?

Works like a charm!

Thank you so much mate

No problems - just don't open another workbook with a different macro, also called PrintPDF in it