Quote:
|
Yes my code is located in Book.xlsx
|
No it isn't... it can't be.
Code can only be saved in an .xlsm (macro enabled) file.
Quote:
|
Also, just a quick question. I'm new to VBA and want to know when to use the "With" command.
|
While in the VBA environment, if you put the cursor in a word and hit F1 Excel will bring up the help page for that word.
A quick Google search for "VBA when to use with" returned
this as one of the top items.