Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Hi,
I am trying to write a simple macros to work down a column and delete the final 3 characters in the Cell. Any ideas? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Jemima,
Right click the sheet tab, view code and paste this in Sub stance() Lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row 'Change to suit Set myrange = Range("A1:A" & Lastrow) For Each c In myrange On Error Resume Next c.Value = Left(c.Value, Len(c.Value) - 3) Next End Sub Mike "Jemima" wrote: Hi, I am trying to write a simple macros to work down a column and delete the final 3 characters in the Cell. Any ideas? Many thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
That code from GS is great! Put it in a module:
http://www.anthony-vba.kefra.com/vba...ur_First_Macro Alternatively, you could use a function such as this: =LEFT(A1,LEN(A1)-3) Regards, Ryan--- -- RyGuy "Mike H" wrote: Jemima, Right click the sheet tab, view code and paste this in Sub stance() Lastrow = Cells(Cells.Rows.Count, "A").End(xlUp).Row 'Change to suit Set myrange = Range("A1:A" & Lastrow) For Each c In myrange On Error Resume Next c.Value = Left(c.Value, Len(c.Value) - 3) Next End Sub Mike "Jemima" wrote: Hi, I am trying to write a simple macros to work down a column and delete the final 3 characters in the Cell. Any ideas? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
AutoRun Macro with a delay to give user the choice to cancel the macro | Excel Programming | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |