| Home |
| Search |
| Today's Posts |
|
#22
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is .Select ever needed?
Thanks, Norman
-- Gordon Rainsford London UK Norman Jones wrote: Hi Gordon, ActiveSheet.AutoFilter.Range.Copy _ Destination:=Sheets("Sheet5").Range("A1") --- Regards, Norman "Gordon Rainsford" wrote in message ... Can someone tell me how to copy and paste a range that has been autofiltered, without selecting it? -- Gordon Rainsford London UK John Coleman wrote: Greetings, I tend to regard .Select as the goto of Excel VBA: it is seldom necessary and makes code harder to read, not to mention slower. Nevertheless, I do sometimes use it - but (if I am honest) only in cases where I do not really understand the object model (which in my case includes things like PasteSpecial and Sort) and thus rely on editing code from the macro recorder. Is it *ever* necessary to select a range before performing some operation involving it? Just curious. Have a good day -John Coleman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| How to select data series to format? (alternative needed) | Charts and Charting in Excel | |||
| Help Needed: ComboBox to select row and Cut xl 97 | Excel Programming | |||
| Select Case Information Needed | Excel Programming | |||
Threaded Mode
