+ Reply to Thread
Results 1 to 2 of 2

Offset now working?

  1. 04-07-2005, 03:58 PM #1
    sleah
    sleah is offline
    Registered User
    Join Date
    03-10-2005
    Posts
    8

    Angry Offset not working?

    Why am I not getting the next blank cell when I use the offset property? It was working fine for me and now all of a sudden it decided to quit.

    Selection.End(xlDown).Select
    ActiveCell.Offset(0, 1).Activate

    when debugging, the first line shows as 8 (the last filled cell). The second line shows as B65536, which is not the next empty cell in the next column, which is what I want to select.

    Am I misunderstanding offset?
    Last edited by sleah; 04-07-2005 at 04:26 PM. Reason: Title incorrect
    Reply With QuoteRegister To Reply
  2. 04-08-2005, 01:57 AM #2
    d61helix
    d61helix is offline
    Registered User
    Join Date
    02-18-2005
    Posts
    26
    when u Selection.End(xlDown).Select, you are selection the last(literally) cell of the column..the last cell, which is no possible cells after the last cell which is row 65536 of every column
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1