Home Delete Entire Row in Specific sheet Based on a value in Excel VBA
Reply: 0

Delete Entire Row in Specific sheet Based on a value in Excel VBA

user5140
1#
user5140 Published in September 19, 2018, 6:48 pm

I have a relatively long subroutine that calls two external subs. In the sub, on one sheet=Start, VBA copies an account number and stores it under the variable name Acct (formatted as string). At the end of the sub, I would like VBA to activate another sheet=Stop, match Acct with a value in Column A (which is formatted as a number), then delete the entire row containing that number. I am just needing some assistance with finding and deleting the entire row containing that number.

It may also be worth mentioning that the numbers in column A are not in numerical order. Also, both sheets are located in the same workbook, we can call WB1.

share|improve this question
  • Either Find() or Match() should do what you need. To delete the found row: EntireRow.Delete – Tim Williams Aug 15 '16 at 23:56

1 Answer 1

active oldest votes
up vote 1 down vote accepted
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.356375 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO