Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Send Keys
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 . . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 giving annoying "Send/Don't Send" error when closing | Excel Discussion (Misc queries) | |||
Send keys with user input | Excel Worksheet Functions | |||
Send keys from command button | Excel Worksheet Functions | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
My send to in excel/word does not offer send as attachment | Excel Discussion (Misc queries) |