vlookup sheet1

[jericho14444]

Hi,

I have a vloopkup code and I was wondering if anyone knew how to change the sheet1 part so the code reads sheet1 every single time, but the tab will be named differently every single month ? Thank you!

.Formula = "=VLOOKUP(C" & .Row & ",'[" & ListBox2.List(j) & "]Sheet1'!$A$4:$B$200,2,FALSE)"

[rcm]

set sheetname to the proper sheet name (month)

Please Login or Register  to view this content.

[tuongtu3]

I'm guessing if this is Sheet(3) regardless sheet name change every month then change to:

Please Login or Register  to view this content.

just guessing
Regards,
tt3

Updated:
Code from rcm is correct

[jericho14444]

Hey Guys,
I changed the formula to

.Formula = "=VLOOKUP(C" & .Row & ",'[" & ListBox2.List(j) & "]" & Sheet(1) & "'!$A$4:$B$200,2,FALSE)"

and it is not working. ANy ideas why? Thank you for all your help thus far.

[jericho14444]

Can someone please help? Thank you.