Getting error running macro

[jrenlmar]

Hi,
I am trying to get the UFBT macro in this spreadsheet to work, but when I try to run it I get an error that says "Compile Error: Variable not defined," and when I hit OK, "Sub UFBT" in my Visual BAsic Editor window is highlighted in yellow.
This macro is supposed to hide eligible rows and columns on two different tabs when run using the macro button in cell J1 on the max store allocation tab

Thank you!
-jrenlmar

[DonkeyOte]

Declare your variable types, eg

Dim wbUFBT As Workbook
Dim wsUFBT1 As Worksheet, wsUFBT2 As Worksheet

You also have a typo

pplication.ScreenUpdating = False

should obviously be

Application.ScreenUpdating = False

I've not verified the accuracy of the code itself.

[Shijesh Kumar]

U need to define the variable before you can use them

add the below lines the the begnning for the procedure

Dim wbUFBT  As Workbook
Dim wsufbt1 As Worksheet
Dim wsUFBT2 As Worksheet

Alternatively u can remove Option Explicit at the top... (Thats considered as bad programming :-))

[shg]

Welcome to the forum, jrenlmar.

Please read the forum rules about thread titles before posting again.