Re: $$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

2011-10-25 Thread dguillett1
- From: DanJ Sent: Monday, October 24, 2011 9:17 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP Dear Sirs, I have a macro which updates my monthly trial balance. But it's too long. Takes time to process. I want to shorten it particularly step 1, step 3 step

$$Excel-Macros$$ HELP: SHORTEN MY MACRO USING LOOP

2011-10-24 Thread DanJ
Dear Sirs, I have a macro which updates my monthly trial balance. But it's too long. Takes time to process. I want to shorten it particularly step 1, step 3 step 4, using loop which i am not very good at. Please help how to shorten my codes. Below is my macro. Thank you. DanJ STEP 1 Sub