Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    65

    Unanswered: Content of a cell based on the ActiveCell

    Hello to all.

    I'm using VBA to evaluate the content of cells on column P. It's working fine but now i've a problem. Is there a way to evaluate the content of the cell belonging to the same line of the ActiveCell but located 8 columns back (column H)?

    Thanks a lot for any kind help.
    Octavio

  2. #2
    Join Date
    Jun 2007
    Posts
    65
    Answering to myself.
    Problem solved by using ActiveCell.Offset(rowOffset, columnOffset)

    Thanks

Posting Permissions

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