| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and If
I am trying to make a macro which cuts and pastes lines into a new worksheet
within the workbook when certain cells are populated with a "Y"...NEver wrote Visual Basic code, only used recorded macros and the 'wizards' within access..Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macros and If
Hi Denise
You can use this add-in if you not want to use code http://www.rondebruin.nl/easyfilter.htm Or use the code on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I am trying to make a macro which cuts and pastes lines into a new worksheet within the workbook when certain cells are populated with a "Y"...NEver wrote Visual Basic code, only used recorded macros and the 'wizards' within access..Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macros and If
I loaded the add-in (what a great idea!) but when I try to run I get a "run
time error 1004" Sort method of range class failed "Ron de Bruin" wrote: Hi Denise You can use this add-in if you not want to use code http://www.rondebruin.nl/easyfilter.htm Or use the code on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I am trying to make a macro which cuts and pastes lines into a new worksheet within the workbook when certain cells are populated with a "Y"...NEver wrote Visual Basic code, only used recorded macros and the 'wizards' within access..Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macros and If
Hi Denise
Send me the workbook private and I will look at it for you Give me also the information on what column you want to filter You can find my mail address here http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I loaded the add-in (what a great idea!) but when I try to run I get a "run time error 1004" Sort method of range class failed "Ron de Bruin" wrote: Hi Denise You can use this add-in if you not want to use code http://www.rondebruin.nl/easyfilter.htm Or use the code on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I am trying to make a macro which cuts and pastes lines into a new worksheet within the workbook when certain cells are populated with a "Y"...NEver wrote Visual Basic code, only used recorded macros and the 'wizards' within access..Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Macros and If
The workbook from Denise is shared
That is the problem Always trouble shared workbooks -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Denise Send me the workbook private and I will look at it for you Give me also the information on what column you want to filter You can find my mail address here http://www.rondebruin.nl/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I loaded the add-in (what a great idea!) but when I try to run I get a "run time error 1004" Sort method of range class failed "Ron de Bruin" wrote: Hi Denise You can use this add-in if you not want to use code http://www.rondebruin.nl/easyfilter.htm Or use the code on this page http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DeniseCost" wrote in message ... I am trying to make a macro which cuts and pastes lines into a new worksheet within the workbook when certain cells are populated with a "Y"...NEver wrote Visual Basic code, only used recorded macros and the 'wizards' within access..Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Linear Mode
