ExcelBanter - View Single Post

Vacuum Sealed

On 12/03/2012 8:03 PM, wrote:
On Mar 12, 1:06 am, Vacuum wrote:
On 12/03/2012 8:51 AM, wrote:

Hi

how can i check the data in in column A when i am in another cell, for
instance if i am in cell g1 i want to check what is in A1, but this
will be variable

many thanks

Hi

Can you clarify what you want to check in Column A.

Would you not be able to see the value in A1 even though you have
selected G1 as the active cell.

Will G1's value, or any other cell have some bearing on the outcome of
specific cells in Column A.

Is Column A subject to sub-totaling or grouping or any other nested
types of formula's that may effect the outcome.

Mick.

Hi

i could be in any column or any row, i have a macro that scrolls down
a column, checking what value is in the A column on the active row i
am in, i was thinking about a simple offset check, but the next time i
run the program i will be starting in the next column so the offset
would change

many thanks

Ok

Now we're getting somewhere.

What is is that your code is not doing, or more specifically, what is it
that you want the offset to do.

Dim c As Range, myRng As Range
Set c = Range("A1:A100") 'change range to suit
For Each c In myRng
If c.Offset(0, 6).Value = c Then
With c
'Do Something
End With
End If
Next c
End Sub

I this is not what you are looking for, post what you have and we'll
suss it out.

Mick.