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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.