Tax Accounting
I had help in developing some code for my project. I am running into an error when I run it and I do not understand why. The error happens at this line...
If c.Offset(0, 5).Value = "NEW_ACCT" Then
which is on the 5th line of code on the attached file.
What the code is supposed to do is to check the East Trial Balance worksheet for any and all entries where NEW_ACCT exists in column F. Taking the Account Number, it is to add the new accounts to each Tax Basis BS worksheet (6) in descending order, copying the formula from column A into the new row as well as columns C thru N (Right now it is only designed to copy columns C thru N.). The Column A formula change the account name to the one from the Trial Balance and if it does not exist, returns a 0. Then we take all rows with 0 in column A and delete them from all six Tax Basis BS (There is Tax Basis BS-SL, -West, -East, Other, -VIE and one just plain Tax Basis BS.
Any help I can get to resolve this error, and to add the feature to copy column a as well as making the whole thing work, will be greatly appreciated.
Pxx-20xx-2.zip
If c.Offset(0, 5).Value = "NEW_ACCT" Then
which is on the 5th line of code on the attached file.
What the code is supposed to do is to check the East Trial Balance worksheet for any and all entries where NEW_ACCT exists in column F. Taking the Account Number, it is to add the new accounts to each Tax Basis BS worksheet (6) in descending order, copying the formula from column A into the new row as well as columns C thru N (Right now it is only designed to copy columns C thru N.). The Column A formula change the account name to the one from the Trial Balance and if it does not exist, returns a 0. Then we take all rows with 0 in column A and delete them from all six Tax Basis BS (There is Tax Basis BS-SL, -West, -East, Other, -VIE and one just plain Tax Basis BS.
Any help I can get to resolve this error, and to add the feature to copy column a as well as making the whole thing work, will be greatly appreciated.
Pxx-20xx-2.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Duh!
All of the 3 "NEW_ACCOUNT" are entered in the array before this error happens.
Cheers,
Curt