|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Hi,
I have the following code, and I get it to delete the row where aCell finds a Y, but I also want to delete the NEXT row as well. Can anyone tell me how to alter my code to do this please? Sub Muppet() Dim aCell For Each aCell In Range("J2", "J58") If aCell = "Y" Then aCell.EntireRow.Delete 'I want something here to help me delete the row aCell +1 End If Next End Sub Thanks! |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > VBA: Multiple Row Delete |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|