Tips for writting macro in Excel
Closed
Abhi
-
Apr 17, 2009 at 12:50 AM
phdhopes Posts 21 Registration date Wednesday September 17, 2008 Status Member Last seen May 11, 2009 - Apr 17, 2009 at 04:55 AM
phdhopes Posts 21 Registration date Wednesday September 17, 2008 Status Member Last seen May 11, 2009 - Apr 17, 2009 at 04:55 AM
Related:
- Tips for writting macro in Excel
- Spell number in excel without macro - Guide
- Macros in excel download - Download - Spreadsheets
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Kernel for excel - Download - Backup and recovery
1 response
phdhopes
Posts
21
Registration date
Wednesday September 17, 2008
Status
Member
Last seen
May 11, 2009
2
Apr 17, 2009 at 04:55 AM
Apr 17, 2009 at 04:55 AM
try this:
With Activesheet
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 1 To LastRow
.Cells(i, "A").Value = Right(.Cells(i, "A").Value, Len(.Cells(i, "A").Value)-1)
Next i
End With
With Activesheet
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
For i = 1 To LastRow
.Cells(i, "A").Value = Right(.Cells(i, "A").Value, Len(.Cells(i, "A").Value)-1)
Next i
End With
