Tips for writting macro in Excel
Closed
Abhi
-
Apr 17, 2009 at 12:50 AM
phdhopes Posts 20 Registration date Wednesday September 17, 2008 Status Member Last seen May 11, 2009 - Apr 17, 2009 at 04:55 AM
phdhopes Posts 20 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
- Excel mod apk for pc - Download - Spreadsheets
- Underlords tips - Guide
- Excel online macros - Guide
- Kernel for excel repair - Download - Backup and recovery
- Cs 1.6 tips - Guide
1 response
phdhopes
Posts
20
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
