Proper use of Commas and Ampersands in relation to variables in VBA code.

[Steve2107]

I have a cell (L1) on a sheet named "Transaction Listing" within a file which records a month name eg. March. There are a number of sheets in this file for each month eg. January Rec, February Rec, March Rec. The code below is supposed to pick up whichever sheet name is referred to at cell "L1" on the Transaction Listing sheet. However, I am doing something wrong in relation to the "Sheets(" & MySelectedMonth & " " & Rec").Select" as I keep getting the error message "Expected: list separator or )". Anyone able to tell me where I am going wrong? Thank you.

Please Login or Register  to view this content.

[stnkynts]

Please Login or Register  to view this content.

[Steve2107]

Thank you so much for that, very much appreciated, I understand what you have done, the only thing I am wondering is this - I note that there is a space between the " and Rec, is this the space that would normally be between say "March Rec"?

[stnkynts]

is this the space that would normally be between say "March Rec"?

That is correct.

[Steve2107]

Terrific, many thanks stnkynts, have a lovely Easter.