Results 1 to 2 of 2

Thread: Excel within vb6

  1. Oct 24th, 2001, 04:05 AM #1
    tg000001
    tg000001 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2001
    Location
    leeds
    Posts
    9

    Excel within vb6

    I am working on a program that opens up excel in vb6 and moves the capures the contents of a specific cell, what I would like to do ie automatically select the next cell in the sequence(ie from d4 to e4) without selecting the next cell as e4.
    some thing like first cell +1 ? is this possible?
    Also I would like to select the last cell say in the "e" col, without
    knowing it's cell address?
    I would really appreciate any advice.
    Reply With Quote Reply With Quote
  2. Oct 24th, 2001, 04:07 AM #2
    da_silvy
    da_silvy is offline
    Conquistador
    Join Date
    Dec 1999
    Location
    Australia
    Posts
    4,527
    Msgbox Worksheets("Sheet1").Range((Worksheets("Sheet1").Col +1) & "4")

    Try that "untested"
    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