Results 1 to 4 of 4

Thread: VBA excel Range into a variable?

  1. Sep 29th, 2003, 09:01 AM #1
    vinesh
    vinesh is offline

    Thread Starter
    New Member
    Join Date
    Sep 2003
    Location
    Leeds
    Posts
    10

    VBA excel Range into a variable?

    Hello

    Does anyone know how i can pass the range (location) of a cell into a variable eg row F5 into x. i have got this far but does not work, what is the correct syntax

    x = xlap.ActiveCell.Range

    thanks in advance
    Reply With Quote Reply With Quote
  2. Sep 29th, 2003, 09:24 AM #2
    adocwra
    adocwra is offline
    Addicted Member
    Join Date
    Aug 2003
    Location
    houston
    Posts
    185
    x = xlap.ActiveCell.Range
    .address
    Reply With Quote Reply With Quote
  3. Sep 29th, 2003, 09:29 AM #3
    vinesh
    vinesh is offline

    Thread Starter
    New Member
    Join Date
    Sep 2003
    Location
    Leeds
    Posts
    10
    i have tried the above but it does not work instead i recieve the error

    run time error 450

    wrong number of arguments or invalid property assignment


    do you think maybe my variable (x) needs to be something other than a string?
    Reply With Quote Reply With Quote
  4. Sep 29th, 2003, 09:41 AM #4
    adocwra
    adocwra is offline
    Addicted Member
    Join Date
    Aug 2003
    Location
    houston
    Posts
    185
    sorry i meant activecell.address
    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