Louisa has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Loops and clearing content
Hi,
I am trying to use a for next loop to clear contents greater than a certain date.
I am using the code I learnt on your course and adjusting it so that instead of copying over certain columns from another sheet it is clearing cells on the current sheet.
Not sure if I am using the right type of loop or what I should do.
Once I have cleared the data I will be replacing info from another sheet.
Not sure if that makes sense. Am I using the right type of loop?
RE: Loops and clearing content
Hello Louisa,
Hope you enjoyed your Microsoft Excel VBA course with Best STL.
Thank you for your question regarding loops and clearing content.
I would appreciate it if you will send me a file containing some data that I could look at and then I can determine how best to clear the required data.
You may send the file to my email address at:
rl@stl-training.co.uk
I await your reply.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
