macro pick 100 lines
Another one:
Activecell.resize(100,1).copy ...
MrDave wrote:
hi, I have some examples been trying, but cannot get a selection of 100 rows
down, from the current cell, that column only. any help appreciated, thanks.
some stuff trying: (with many variations)
Sub Copy() 'alt-, (comma) wip: copy column 190 rows down from active
cell, pending
'reduce all windows, restore main window, pause conflict with ie, etc.
click button does not work
'Rows(ActiveCell.Row).Select
Cells(ActiveCell.Cells).Select
'Rows(ActiveCell.Row) Offset(0, 180).Select
'.Offset(0, 180).Select
'Selection.Copy
'ActiveWindow.LargeScroll Down:=4
'Columns(ActiveCell.Column).Select
'Rows(ActiveCell.Row).Select
'Selection.Copy
End Sub
--
Dave Peterson
|