changing active cell
 

Can I move the active cell around in VBA like I use to do in Lotus? ie up3,
right7 etc

changing active cell
 

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc

changing active cell
 

Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc

changing active cell
 

Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc

changing active cell
 

U¿ytkownik "doug" napisa³ w wiadomo¶ci
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc





maybe ActiveCell.Offset(-3, 7) goes out of spredsheet?
mcg

changing active cell
 

Starting at cell L51, the first line works good when alone,


Selection.EntireRow.Insert
ActiveCell.Offset(0,-3)


"Stuart" wrote:

Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc

changing active cell
 

Selection.EntireRow.Insert
ActiveCell.Offset(0,-3).Select

but hopefully you will give up this approach and learn how to program in
VBA -- which doesn't mimic cursoring around the worksheet.

--
Regards,
Tom Ogilvy

"doug" wrote in message
...
Starting at cell L51, the first line works good when alone,


Selection.EntireRow.Insert
ActiveCell.Offset(0,-3)


"Stuart" wrote:

Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus?
ie
up3,
right7 etc

changing active cell
 

I thought that was what I was doing. What would the VBA code be to insert a
row and be positioned in the A column of that row from anywhere in the
worksheet?

"Tom Ogilvy" wrote:

Selection.EntireRow.Insert
ActiveCell.Offset(0,-3).Select

but hopefully you will give up this approach and learn how to program in
VBA -- which doesn't mimic cursoring around the worksheet.

--
Regards,
Tom Ogilvy

"doug" wrote in message
...
Starting at cell L51, the first line works good when alone,


Selection.EntireRow.Insert
ActiveCell.Offset(0,-3)


"Stuart" wrote:

Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus?
ie
up3,
right7 etc

changing active cell
 

Sub aa()
Rows(ActiveCell.Row).Insert
Cells(ActiveCell.Row, 1).Select
End Sub


--
Regards,
Tom Ogilvy



"doug" wrote in message
...
I thought that was what I was doing. What would the VBA code be to insert
a
row and be positioned in the A column of that row from anywhere in the
worksheet?

"Tom Ogilvy" wrote:

Selection.EntireRow.Insert
ActiveCell.Offset(0,-3).Select

but hopefully you will give up this approach and learn how to program in
VBA -- which doesn't mimic cursoring around the worksheet.

--
Regards,
Tom Ogilvy

"doug" wrote in message
...
Starting at cell L51, the first line works good when alone,


Selection.EntireRow.Insert
ActiveCell.Offset(0,-3)


"Stuart" wrote:

Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in
Lotus?
ie
up3,
right7 etc