Trying to insert rows in a Macro
It says Go to:
$A$2
$A$1
"Barb Reinhardt" wrote:
Type CTRL G to go to your IMMEDIATE window. It should show an address of
some kind.
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"jerryb123" wrote:
It doesn't seem to change anything that happens--I still get the same error
message. Does this generate an error report or something?
"Barb Reinhardt" wrote:
I think I'd put this in before the line with the error.
Debug.print selection.address
What does it tell you?
--
HTH,
Barb Reinhardt
If this post was helpful to you, please click YES below.
"jerryb123" wrote:
Hello, all:
I'm trying to record a macro that will autofilter a selection, select all
visible rows, and insert new rows. Here is the section of the code generated
by the Macro Recorder:
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=2, Criteria1:="1"
Rows("2:2234").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Insert Shift:=xlDown
It always hangs up on the last line, with the following message:
Run-time error '1004':
Insert method of Range class failed
I can't figure out why it isn't working; any suggestions or help are greatly
appreciated. Thanks!
|