Results 1 to 2 of 2

Thread: VBA with Excel Problem

  1. Mar 16th, 2002, 11:32 AM #1
    MrFoxy
    MrFoxy is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2002
    Posts
    78

    VBA with Excel Problem

    I have been using Range("Cellvalue").Formula and similar for a while, but I found I can't use variables as the cell references, only text.

    Is there a similar cell selecting/editing/value grabbing function that I can use instead
    Reply With Quote Reply With Quote
  2. Mar 16th, 2002, 01:26 PM #2
    ae_jester
    ae_jester is offline
    Frenzied Member ae_jester's Avatar
    Join Date
    Jun 2001
    Location
    Kitchener Ontario Canada Earth
    Posts
    1,545
    Are you sure?

    I've been using variable names

    VB Code:
    1. Dim tempStr as string

    2. tempStr = "A" + 1

    3. Range(tempstr).blablabla 'works for me


    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