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