Results 1 to 3 of 3

Thread: [RESOLVED] Stupidity from MS

  1. Jul 20th, 2005, 04:24 AM #1
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Resolved [RESOLVED] Stupidity from MS

    Hi again.

    It's about Excel - when I work with VBA (cells(x,y)), VBA demands a number for the column. But in Excel, the columns has letters! I think I've counted wrong, so my question is: How can I get the columns' letters to be numbers instead?
    Reply With Quote Reply With Quote
  2. Jul 20th, 2005, 04:46 AM #2
    njwilli3
    njwilli3 is offline
    Junior Member
    Join Date
    Mar 2005
    Posts
    30

    Re: Stupidity from MS

    tools - options - general - R1C1 referance style (tick it)
    Reply With Quote Reply With Quote
  3. Jul 20th, 2005, 05:00 AM #3
    sveegaard
    sveegaard is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2005
    Posts
    236

    Talking Re: Stupidity from MS

    Thanx
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width