I posted a question on the 18th "How do I move to a specified row and
insert a value?" and I was wondering if anyone knew how to solve it, my
outstanding issues a

Help!!! I can't get this code to work, what am I doing wrong??

varRef = Target.Address
varVal = Target.Value

varRow = Me.Range(varRef).Row
varCol = Me.Range(varRef).Column

---- this works above this line ----------

' Q.(1) am I supposed to declare rng as a Range ?
Dim rng As Range

' Q.(2) how do I populate the range, like this?
rng = Target

'Q.(3) Is this how I do this for row 5 (and then I'll do the same for the
other row)?
If rng.Row = 5 Then Set rng = rng.Offset(3, 0)


I've tried numerous combinations and Excel keeps generating error messages.
I wonder if it is in relation to declaring 'rng' and/or then populating it,
and/or
then finally setting it to offset as above.

Please can anyone help with this issue?

1. post your full code
2. indicate which line fails
3. give Excel's full error message
--
Gary''s Student - gsnu200821


"LuvMyTennis" wrote:

I posted a question on the 18th "How do I move to a specified row and
insert a value?" and I was wondering if anyone knew how to solve it, my
outstanding issues a

Help!!! I can't get this code to work, what am I doing wrong??

varRef = Target.Address
varVal = Target.Value

varRow = Me.Range(varRef).Row
varCol = Me.Range(varRef).Column

---- this works above this line ----------

' Q.(1) am I supposed to declare rng as a Range ?
Dim rng As Range

' Q.(2) how do I populate the range, like this?
rng = Target

'Q.(3) Is this how I do this for row 5 (and then I'll do the same for the
other row)?
If rng.Row = 5 Then Set rng = rng.Offset(3, 0)


I've tried numerous combinations and Excel keeps generating error messages.
I wonder if it is in relation to declaring 'rng' and/or then populating it,
and/or
then finally setting it to offset as above.

Please can anyone help with this issue?

Q.(1) am I supposed to declare rng as a Range ?
Dim rng As Range

The code is more efficient when all variables are declared.

' Q.(2) how do I populate the range, like this?
rng = Target

If rng is a single cell then rng = Target.Value might work if you are
running
event code with (ByVal Target as Range).

'Q.(3) Is this how I do this for row 5 (and then I'll do the same for the
other row)?
If rng.Row = 5 Then Set rng = rng.Offset(3, 0)

Is this how you do what for row 5?
The code is OK but I don't understand the question.

I've tried numerous combinations and Excel keeps generating error messages.

Do you click the Help button when the error messages appear?
That generally explains what is causing the error.

I wonder if it is in relation to declaring 'rng' and/or then populating it,
and/or then finally setting it to offset as above.

If you would post the actual code that you are using and give a concise
explanation of what you are trying to accomplish, I am pretty sure that some
of the folks who monitor this site could help.

"LuvMyTennis" wrote:

I posted a question on the 18th "How do I move to a specified row and
insert a value?" and I was wondering if anyone knew how to solve it, my
outstanding issues a

Help!!! I can't get this code to work, what am I doing wrong??

varRef = Target.Address
varVal = Target.Value

varRow = Me.Range(varRef).Row
varCol = Me.Range(varRef).Column

---- this works above this line ----------

' Q.(1) am I supposed to declare rng as a Range ?
Dim rng As Range

' Q.(2) how do I populate the range, like this?
rng = Target

'Q.(3) Is this how I do this for row 5 (and then I'll do the same for the
other row)?
If rng.Row = 5 Then Set rng = rng.Offset(3, 0)


I've tried numerous combinations and Excel keeps generating error messages.
I wonder if it is in relation to declaring 'rng' and/or then populating it,
and/or
then finally setting it to offset as above.

Please can anyone help with this issue?