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
rawilkenAsked:
Who is Participating?
 
Curt LindstromConnect With a Mentor Commented:
To get rid of the #REF! errors you can just copy the formulas in the "East Trial Balance" worksheet on line 609 downwards.

Curt
0
 
Curt LindstromCommented:
The "Type Mismatch" error comes on line 610 when you read the #REF! error in cell F610. Correct the source of the the #REF! error to get past the "Type Mismatch" error.

All of the 3 "NEW_ACCOUNT" are entered in the array before this error happens.

Cheers,
Curt
0
 
rawilkenAuthor Commented:
Duh!
0
All Courses

From novice to tech pro — start learning today.