Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset question
I want this code to function on the current position, 13th column
So if I am in A1 it should be looking at M1 If ActiveSheet.Range(1, 13) = "" Then OptNoL.Value = True ElseIf ActiveSheet.Range(1, 13) = 30 Then opt30L.Value = True ElseIf ActiveSheet.Range(1, 13) = 60 Then opt60l.Value = True |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset question
H Patrick.
Try: With ActiveCell.Offset(0,12) If .Value = "" Then OptNoL.Value = True ElseIf .Value = 30 Then opt30L.Value = True ElseIf .Value = 60 Then opt60l.Value = True Else 'Leave unchanged '<<===== ??? End If End With (Note that Range("A1").Offset(1,13) returns the N2 cell) --- Regards, Norman "Patrick Simonds" wrote in message ... I want this code to function on the current position, 13th column So if I am in A1 it should be looking at M1 If ActiveSheet.Range(1, 13) = "" Then OptNoL.Value = True ElseIf ActiveSheet.Range(1, 13) = 30 Then opt30L.Value = True ElseIf ActiveSheet.Range(1, 13) = 60 Then opt60l.Value = True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset question | Excel Discussion (Misc queries) | |||
MOD of OFFSET question? | Excel Discussion (Misc queries) | |||
Offset Question | Excel Worksheet Functions | |||
Offset Question | Excel Worksheet Functions | |||
OFFSET() question for '97 | Excel Discussion (Misc queries) |