Macros and If

[DeniseCost]

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!

 

[Ron de Bruin]

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

 

[DeniseCost]

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]

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/

 

[Ron de Bruin]

The workbook from Denise is shared

That is the problem
Always trouble shared workbooks