bestschnauzermom
New Member
- Joined
- Aug 9, 2019
- Messages
- 5
I am new to VERY new to macro building but I have reworked one that has been used where I work. I need to add a macro to the beginning of the one in use now to delete any rows that has the word "MISCELLANEOUS" in column C but NOT to delete the row if it has the word "CONCENTRATION" is in column I. I'll give an example:
Column C Column I
MISCELLANEOUS NASHVILLE, TN
MISCELLANEOUS CONCENTRATION
MISCELLANEOUS ONTARIO, CA
After this section of the macro runs I need it to continue running the current macro I have set up which starts like this:
Sub Import_From_Download()
'Make sure the download is the active document/with correct sheet.
Windows("June 17-Fees Charged.csv").Activate
Sheets("June 17-Fees Charged").Select
'Declare Variables
Dim i As Long, iLimit As Long
Dim split_text As Variant
Dim split_test(0 To 1000000) As Variant
Dim acct_st(1 To 50) As Variant
Dim acct_cr(1 To 50) As Variant
Dim acct_db(1 To 50) As Variant
'setup (assign values to) account number array
acct_st(1) = "205273"
acct_st(2) = "205275"
acct_st(3) = "205272"
acct_st(4) = "205276"
acct_st(5) = "205278"
'acct_st(5) = "205278"
Everything I have tried either gives me an error OR doesn't work at all so I'm lost. Any help is appreciated.
Column C Column I
MISCELLANEOUS NASHVILLE, TN
MISCELLANEOUS CONCENTRATION
MISCELLANEOUS ONTARIO, CA
After this section of the macro runs I need it to continue running the current macro I have set up which starts like this:
Sub Import_From_Download()
'Make sure the download is the active document/with correct sheet.
Windows("June 17-Fees Charged.csv").Activate
Sheets("June 17-Fees Charged").Select
'Declare Variables
Dim i As Long, iLimit As Long
Dim split_text As Variant
Dim split_test(0 To 1000000) As Variant
Dim acct_st(1 To 50) As Variant
Dim acct_cr(1 To 50) As Variant
Dim acct_db(1 To 50) As Variant
'setup (assign values to) account number array
acct_st(1) = "205273"
acct_st(2) = "205275"
acct_st(3) = "205272"
acct_st(4) = "205276"
acct_st(5) = "205278"
'acct_st(5) = "205278"
Everything I have tried either gives me an error OR doesn't work at all so I'm lost. Any help is appreciated.