Using variables in vb for Excel
Results 1 to 3 of 3

Thread: Using variables in vb for Excel

  1. #1
    Registered User
    Join Date
    Apr 2001
    Location
    Pretoria, South Africa
    Posts
    22

    Angry Using variables in vb for Excel

    How can I select cells using a variable ?
    I have been trying to use this:
    (h)is a variable, and yes, it does contain a value...

    range (h).select
    range ("h").select
    range (h$).select
    range ("h$").select

    nothing seems to work.

    Thanx in advance

    Yoda Knight

  2. #2
    StevePorter
    Guest

    Question

    Are you trying to assign a value to a cell, or trying to get a value within a cell assigned to a variable? It would help to know a bit more about what you're trying to accomplish...

    ------------------
    Some computer problems require extreme solutions. Spaceman Spiff sets his blaster on deep fat fry...

  3. #3
    StevePorter
    Guest

    Red face

    Please don't double-post. Go here to consider my response...

    ------------------
    Some computer problems require extreme solutions. Spaceman Spiff sets his blaster on deep fat fry...

Bookmarks

Posting Permissions

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