Send Keys
Pancho,
Could be. I'm still in the "dark ages" with 97 (can't update until all my
users update - what a ?@#@#!)
--
sb
"pancho" wrote in message
...
maybe is an Excel 2000+ feature, because, when I copy the
current region of a filetered data then I paste only the
visible data
Francisco Mariscal
fcomariscal at hotmail dot com
-----Original Message-----
Pancho,
When I copy the current region and paste, I get
everything. Even the
hidden cells. That is why I select only the visible
cells.
--
sb
"pancho" wrote in message
...
When I need to do this I prefer to copy the data,
create a
temporary sheet and then paste the data on it (It will
be
only the filtered data dat you have pasted on that
sheet)
The following code will do that:
Dim sh as Worksheet
Selection.CurrentRegion.Select
Selection.Copy
set sh=Sheets.Add
sh.Paste
Application.CutCopyMode = False
(here you can use your filtered data)
and finnaly you can delete the temporary sheet with:
Application.DisplayAlerts = False
sh.Delete
Application.DisplayAlerts = true
I hope this can be useful.
Francisco Mariscal
fcomariscal at hotmail dot com
-----Original Message-----
I have a large list of data; on which I have applied
automatic filtering.
Thereafter, I use filter conditions on one of the
columns
only to show selected records.
Thereafter I want to automatically run down this column
and do specific actions for each value in this column.
I
am able to do everything I want EXCEPT run down this
column.
The ACTIVECELL.OFFSET(1,0) obviously gives the
physically
next record; and so is not useful.
I tried SENDKEYS "{DOWN}" to simulate pressing the down
key; but for some strange reason it takes me to the
last
item in that column !!
I tried SENDKEYS "{ENTER}" to simulate pressing the
ENTER
key. But nothing happens.
Thus, currently I have to manually press enter every
time
before triggering off my macro.
Any help will be useful.
I do not want to write a FIND routine because
eventually
in my filter I may set filter conditions on several
fields
and then run down a column; in which case my FIND
routines
may not be that reliable or scalable.
Many thanks
.
.
|