If you have one row of data, what's the easie
Closed
usha
-
Feb 24, 2010 at 03:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 05:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 05:45 AM
Related:
- If you have one row of data, what's the easie
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Saints row 2 cheats - Guide
- Display two columns in data validation list but return only one - Guide
- How to be offline in whatsapp when data is on - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 24, 2010 at 04:28 AM
Feb 24, 2010 at 04:28 AM
You can use formula and auto filter combo to delete the rows
or you can use this macro
or you can use this macro
Sub fixAndDeleteAlternateRow()
Dim startAtRow, endAtRow, rowCounter As Long
startAtRow = 2
endAtRow = 100
For rowCounter = startAtRow To endAtRow
Cells(rowCounter - 1, 1) = Cells(rowCounter - 1, 1) & Cells(rowCounter, 1)
Rows(rowCounter).Select
Selection.Delete Shift:=xlUp
Next
End Sub
Feb 24, 2010 at 05:42 AM
thanks but if i have use this macro run time error 28 is coming plz help.
Feb 24, 2010 at 05:45 AM