Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros
I am trying to create the simplest of macros. I just want to delete the first
4 characters of a cell, and then have it repeat that process for about 350 cells. Everytime I hit record and give it a name and hot key. I preform the steps of deleting 4 characters in a cell and hit enter to goto the next cell. I hit stop recording and then try to run the macro, which at this point does not work.. Can ANYONE HELP. What am I doing wrong Thanks Brian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros
Hi Brian,
Assuming that you have data in column A and that the first cell is A1, the following macro should do the job. It will do nothing if there are four or fewer characters in a cell. Option Explicit Dim CountRows As Double Dim Iloop As Double Sub DeleteCharacters() 'Turn off warnings, etc. Application.ScreenUpdating = False Application.DisplayAlerts = False CountRows = Cells(Rows.Count, "A").End(xlUp).Row For Iloop = 1 To CountRows If Len(Cells(Iloop, "A")) 4 Then Cells(Iloop, "A") = Right(Cells(Iloop, "A"), _ Len(Cells(Iloop, "A")) - 4) End If Next Iloop 'Turn off warnings, etc. Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub -- Ken Hudson "Brian" wrote: I am trying to create the simplest of macros. I just want to delete the first 4 characters of a cell, and then have it repeat that process for about 350 cells. Everytime I hit record and give it a name and hot key. I preform the steps of deleting 4 characters in a cell and hit enter to goto the next cell. I hit stop recording and then try to run the macro, which at this point does not work.. Can ANYONE HELP. What am I doing wrong Thanks Brian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros
Sub trimleftfour()
lr = Cells(Rows.Count, "f").End(xlUp).Row For Each c In Range("f2:f" & lr) c.Value = Right(c, Len(c) - 4) Next c End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Brian" wrote in message ... I am trying to create the simplest of macros. I just want to delete the first 4 characters of a cell, and then have it repeat that process for about 350 cells. Everytime I hit record and give it a name and hot key. I preform the steps of deleting 4 characters in a cell and hit enter to goto the next cell. I hit stop recording and then try to run the macro, which at this point does not work.. Can ANYONE HELP. What am I doing wrong Thanks Brian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros
What are you doing wrong.........?
You cannot record or run a macro while in Edit mode which is the mode you are in when deleting the first four characters. See the macros from Don and Ken to get what you want. Gord Dibben MS Excel MVP On Tue, 18 Mar 2008 14:27:01 -0700, Brian wrote: I am trying to create the simplest of macros. I just want to delete the first 4 characters of a cell, and then have it repeat that process for about 350 cells. Everytime I hit record and give it a name and hot key. I preform the steps of deleting 4 characters in a cell and hit enter to goto the next cell. I hit stop recording and then try to run the macro, which at this point does not work.. Can ANYONE HELP. What am I doing wrong Thanks Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros | Charts and Charting in Excel | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |