Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ChrizDK

    Offset to the next visible cell

    I like your solution Loomah. Will try to implement it and see how it works out. Best regards, Christian
  2. ChrizDK

    Offset to the next visible cell

    Hello, i tried searching for an answer to this but couldn't find one. If it's already covered i appologize for my ignorance. I'm using the Offset function to move through my cells: EXAMPLE: ActiveCell.Offset([-1], [0]).Select This will move down to the next cell in my spreadsheet. If i use...
  3. ChrizDK

    Updating selection while using the filter function

    Thanks xlbo, that did the trick. :O) Christian
  4. ChrizDK

    Updating selection while using the filter function

    Hi' I have the following code: (made by Murad5 on this board) Sub marker() Dim myRange As Range, cel As Range Set myRange = Selection For Each cel In myRange cel.Offset(0, 1).Value = "x" Next End Sub I would like the functionality to work, when the cells...
  5. ChrizDK

    Updating cells based on selected range

    Murad5, i've been using your code and has actually run into a limitation, that i'm quite sure that you can help me overcome. If the sheet uses the autofilter function the cells included in the selection (when using 'drag' selection) is not only the cells visible but also any cells not in sight...
  6. ChrizDK

    Updating cells based on selected range

    Hi Murad5, thanks for the code - it works fabulously. Cheers and a star to you Christian
  7. ChrizDK

    Updating cells based on selected range

    Hi, I was wondering if the following was possible using VBA in Excel: The user marks a range in a column - this could be a multiple selection using CTRL + LeftMouseButton. I would then like to update the cell next to the selected range with e.g. a X - meaning that the cell was part of a...

Part and Inventory Search

Back
Top