Modification of Dim code to allow a 2nd similar batch of code.

  • I have working code to call a message & file. However when I tried to modify the working to allow a similar message & file call, I get a message, that the Dim is a duplicate. The only difference between the working code & the 2nd batch of code is the cell range. Working code cell range is B4:B17 &B:B, the second batch range is J. Please educate me regarding the changes, I have to make.

  • Can you post a sample?

  • Problem solved. I had to use 3 different batches of code . Batch 1) Beginning of FY; Batch 2) worksheets between the Beginning & End; Batch 3) End of fiscal year.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!