I understand most of this - but I am slighly stumpped on a minor issue.
I've searched for and found a column header - let's call it "LOAN"
Sheets(MainWkSht).Select
Set r = Cells.Find("LOAN")
If r <> "LOAN" then
goto oops
else goto Foundit
end If
'Now grap the column and cell where the header was found ("B1")
location = Cells((r.Column) - 1).Address(0, 0)
'Now strip of the "1" making the result Column ("B")
Location2 = Left(location, InStr(location, "1") - 1)
My question is this. Lets say I want to do something to what ever column to the left or right of where this "LOAN" was found.
How can I manipulate the formula to add or subtract columns from the formula:
Cells(2,location).Select
lets say I want to Identify the 5th column to the right of the string: Location
suggestions?
Thanks.
I've searched for and found a column header - let's call it "LOAN"
Sheets(MainWkSht).Select
Set r = Cells.Find("LOAN")
If r <> "LOAN" then
goto oops
else goto Foundit
end If
'Now grap the column and cell where the header was found ("B1")
location = Cells((r.Column) - 1).Address(0, 0)
'Now strip of the "1" making the result Column ("B")
Location2 = Left(location, InStr(location, "1") - 1)
My question is this. Lets say I want to do something to what ever column to the left or right of where this "LOAN" was found.
How can I manipulate the formula to add or subtract columns from the formula:
Cells(2,location).Select
lets say I want to Identify the 5th column to the right of the string: Location
suggestions?
Thanks.