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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get ActiveSheet to work...
See response to your earlier post.
Have a little patience please. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 15:58:31 -0000, wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't get ActiveSheet to work...
On Aug 16, 11:33 am, Gord Dibben <gorddibbATshawDOTca wrote:
See response to your earlier post. Have a little patience please. Gord Dibben MS Excel MVP On Thu, 16 Aug 2007 15:58:31 -0000, wrote: 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- Hide quoted text - - Show quoted text - Thanks - Sorry for the dup post. I didn't see it come up on my older post, so I decided to make it a new post. My mistake. |
Reply |
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) |