How to use a cell value in a macro

[kal46]

Hi, I am trying to use a cell value in a macro to change what it does.

I want a macro to run Autofilter, Sort and Hide/Unhide columns, and selecting sheets based on certain cells.


For example, on my spreadsheet of race times for various events I may want columns X:Z hidden if the user selected to not see that event.

I was going to use a DDL for the user to select which event they want to see, then in a seperate cell use a lookup to return the cells to be hidden. eg. User selects "round 1" and cell "Home!N3" will return X:Z. I want to use the value of the cell "X:Z" in the macro.

As I said above, I have a few applications for this, so is there a simple way of just adding the cell value as and where I need it? I do not know much VBA, just enough to basically read it and edit it as I need to. When I go to my recorded macro for any of the uses I mentioned above, I want to be able to change, for example, "X:Z" to a code amounting to the value of the cell with the information in it "Home!N3".


I have tried just changing to a different sheet with no luck and have tried many combinations of something like Sheets("Champs!C5".Value).Select


Any help, or advice of what to search on and learn would be appreciated.

Thanks, KAL46

[HaHoBe]

Hi, kal46,

assuming that cell C10 delivers the string M:Q and that you want to hide the columns M to Q on the active sheet:

Please Login or Register  to view this content.

Regarding the changing of a worksheet (I really donīt see a necessity to do so), the name of the worksheet is in C5 on Sheet Champs:

Please Login or Register  to view this content.

Cia,
Holger

[kal46]

Hi Holger,

That's great. Both work, also used the same basis for autofilter and that worked too. Just got to try using it on my sort function and that will be it all done, i'll try it tomorrow.

Thanks again. KAL46