Re: Force Caps Lock

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chip Pearson (chip_at_cpearson.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 15:52:06 -0500

> For Each r in Sheets("Template").Range("A9:C43").Value

This should be

 For Each r in Sheets("Template").Range("A9:C43").Cells 

-- 
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"kkknie >" <<kkknie.16tls7@excelforum-nospam.com> wrote in
message news:kkknie.16tls7@excelforum-nospam.com...
> I was afraid that wouldn't work.  Should have tested (duh).
>
> Modify to this:
>
> Dim r as Range
>
> For Each r in Sheets("Template").Range("A9:C43").Value
> r.Value = UCase(r.Value)
> Next
>
> This will loop through the cells individually and should work.
>
> K
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: Force Caps Lock
    ... Sorry for being a pain KK but I'm still getting a debug ... > I was afraid that wouldn't work. ... Should have tested (duh). ... > Modify to this: ...
    (microsoft.public.excel.programming)
  • Re: Send Object Action
    ... >Is it possible to modify that list to only show certain types ie excel and ... > the output format, a popup box will appear asking what ... > list to only show certain types ie excel and access ...
    (microsoft.public.access.externaldata)
  • Re: VB offset error from Jack Dahgrens Code
    ... I had moved a few lines of code due to another macro. ... > I just tried it with the Excel 11 object library and it works fine. ... > Dim xlRow As Excel.Range ... >>> modify the file so that is no longer there. ...
    (microsoft.public.project)
  • Re: Excel 2007 password bug
    ... modify the workbook but must save it with a DIFFERENT name ... Microsoft Excel MVP ... The BUG is when another user opens the file in "READ-ONLY" mode who ...
    (microsoft.public.excel)
  • Re: Form in new message layout
    ... The user certainly should be able to modify the message before they send. ... This technique does not send an attachment, ... > the grid lines and usual excel layout. ...
    (microsoft.public.outlook.program_forms)