-
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
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