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
- Saints row 2 cheats - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
- Data transmission cable - 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