Menu

checking data in the A column

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

Vacuum Sealed Vacuum Sealed is offline

Vacuum Sealed is offline

external usenet poster

Posts: 259

Default

checking data in the A column

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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checking Column Entries	gtb	Excel Worksheet Functions	9	November 3rd 08 06:10 AM
Checking entries against a column of data	TonyR	Excel Discussion (Misc queries)	1	May 31st 07 07:21 PM
Checking a cell's (Row,Column)	Craig[_21_]	Excel Programming	3	December 25th 05 01:47 PM
checking celll in column	withblue	New Users to Excel	3	May 26th 05 08:39 PM
checking value in column	sals	Excel Programming	1	December 18th 03 08:01 PM

All times are GMT +1. The time now is 09:37 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement