cellsh

  1. T

    Macro / VBA: Macro Failling

    Hi! I have a macro that loops throughout a list of tab names. The macro is only applied to certain tabs. The macro fails on the "Sheets(w).Select" line. Any suggestions? Sub Hide_Unused_Rows() Dim ws As Worksheet Dim Worksheets As Variant Application.ScreenUpdating = False Worksheets =...
  2. K

    Opening a userform on a different sheet than the reference data used in the initialize process

    Here is my issue. When i open my userform on any sheet other than the sheet "Data Entry" or sheet3 in my case, my initialization fails because i reference a dynamic range on sheet3. I found away around it by selecting sheet3 at the beginning and jumping back to the activesheet at the end. but i...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top