Forum Discussion
macro messing up and i need help understanding VBA
this is not the entire vba as its a long recorded macro but when using step into this is the section that messes up. it hits the same error further down the sheet when it recorded the same filter but...
try this in a test workbook..
always have a back-up copy of your work
always have a back-up copy of your work
attached is a sample file for your to test..
- I usually used the "Record Macro" for some repetitive tasks
then tweak the codes to make it work as required..
Like LEGO, make some modules, test them then plug it in...i was using record macro. for some reason when it was recorded within a long macro it wouldn't work but when i recorded just the filter then created a master macro using the "call" command to insert the filter macro into the rest of it everything worked fine. even compared the coding and it was identical. doesn't make sense to me but its working from doing that. sorry didn't see your posts until today. not sure if what you did would work since i don't want to mess up what i have working now but maybe it will help someone else. been trying to teach myself VBA the past 2 weeks with no prior programming skills and it's been a hassle with google and excel's "step in-to" as my only resources.
- also, you may attach a "dummy" file of yours for many good men here to analyze.. click Choose files ..
