Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get ActiveSheet to work...
I have tried to add ActiveSheet to the following code (which ya'll
helped with yesterday), but can't get it to work actually run on all the sheets.... Here's the code: Sub RemoveCR() Dim R As Range For Each R In Range("C1:C20000") If R.Value Like "*[Cc][Rr]" Then R.Value = -Left(R.Value, Len(R.Value) - 2) End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveSheet.Paste (error) | Excel Worksheet Functions | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
ActiveSheet.Paste - Error help? | Excel Discussion (Misc queries) | |||
Difference between Activesheet.unprotect | Excel Discussion (Misc queries) |