Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

ActiveCell.Offset(-1, -10).Select

Regards,
Paul

"jsd219" wrote in message
oups.com...
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

ok, what am i doing wrong here?

Set rng = ActiveCell.Offset(-1, -10).Select

i get an error

God bless
jsd219


PCLIVE remove this wrote:
ActiveCell.Offset(-1, -10).Select

Regards,
Paul

"jsd219" wrote in message
oups.com...
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

you don't use select at the end

Set rng = ActiveCell.Offset(-1, -10)
rng.Select

but you rarely need to select, you can just act on the rng
--


Gary


"jsd219" wrote in message
ups.com...
ok, what am i doing wrong here?

Set rng = ActiveCell.Offset(-1, -10).Select

i get an error

God bless
jsd219


PCLIVE remove this wrote:
ActiveCell.Offset(-1, -10).Select

Regards,
Paul

"jsd219" wrote in message
oups.com...
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

Set rng = ActiveCell(0, -9)

Alan Beban

jsd219 wrote:
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

Here is a problem i am having, i need to not only make the range start
one row above the selected cell but i also need it to cover multiple
columns. any ideas?

God bless
jsd219

Alan Beban wrote:
Set rng = ActiveCell(0, -9)

Alan Beban

jsd219 wrote:
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

give us an example of exactly what you're trying to do

--


Gary


"jsd219" wrote in message
ups.com...
Here is a problem i am having, i need to not only make the range start
one row above the selected cell but i also need it to cover multiple
columns. any ideas?

God bless
jsd219

Alan Beban wrote:
Set rng = ActiveCell(0, -9)

Alan Beban

jsd219 wrote:
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

Sure this is a post from an earlier thread:

I am trying to write a script that looks for a cell with specified text
in a specified column, once it finds the cell it needs to check six
different columns (a,b,c,d,e,f) one row above and find the column that
has an "x", it then needs to place an "x" in its row one column to the
right from the previous "x"

example: if it finds the cell with "Went up the hill" the script needs
to look up one row and check columns (a,b,c,d,e,f) until it finds the
"X".

In this case it will find the "X" on the row with "JACK AND JILL" in
column "a" so it will place an "X" for the row "Went up the hill" (the
orginal cell searched for) in column "b"

a b c d e f g
X JACK AND JILL

Went up the hill

To fetch 3.5 Pales

God bless
jsd219


Gary Keramidas wrote:
give us an example of exactly what you're trying to do

--


Gary


"jsd219" wrote in message
ups.com...
Here is a problem i am having, i need to not only make the range start
one row above the selected cell but i also need it to cover multiple
columns. any ideas?

God bless
jsd219

Alan Beban wrote:
Set rng = ActiveCell(0, -9)

Alan Beban

jsd219 wrote:
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219

Dim rng as Range, rng1 as Range
Dim res as variant
set rng = cells.Find("Went up the hill")
set rng1 = cells(rng.row-1,"A").resize(1,6)
res = application.Match("x",rng1,0)
if not iserror(res) then
cells(rng.row,res + 1).Value = "x"
end if

What happends if the match was made in F; write to G?


What happended to Don?

--
Regards,
Tom Ogilvy



"jsd219" wrote in message
ups.com...
Sure this is a post from an earlier thread:

I am trying to write a script that looks for a cell with specified text
in a specified column, once it finds the cell it needs to check six
different columns (a,b,c,d,e,f) one row above and find the column that
has an "x", it then needs to place an "x" in its row one column to the
right from the previous "x"

example: if it finds the cell with "Went up the hill" the script needs
to look up one row and check columns (a,b,c,d,e,f) until it finds the
"X".

In this case it will find the "X" on the row with "JACK AND JILL" in
column "a" so it will place an "X" for the row "Went up the hill" (the
orginal cell searched for) in column "b"

a b c d e f g
X JACK AND JILL

Went up the hill

To fetch 3.5 Pales

God bless
jsd219


Gary Keramidas wrote:
give us an example of exactly what you're trying to do

--


Gary


"jsd219" wrote in message
ups.com...
Here is a problem i am having, i need to not only make the range start
one row above the selected cell but i also need it to cover multiple
columns. any ideas?

God bless
jsd219

Alan Beban wrote:
Set rng = ActiveCell(0, -9)

Alan Beban

jsd219 wrote:
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1
row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219