Hi ,
How to select visible rows in autofilter range..
i want to select column b visible cells on a filter put on col c...
How to do it..
And how to stop trigger event for a particular column to interfere in the existing macro in that column..
used enable events false in the existing macro, but still the trigger event makes the macro go to debug in the start..
this am saying, becoz when the event is deleted, original macro works fine..
Welcome to the forum
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Hi,
I have attached file..
the macro not working..
i have a click event and a macro in a module..
the event makes the macro not working..
Tere is something wrong with your original file. After copying data from sheet1(2) and Sheet3 I could run your macro (step through it) and it complained about "no data" as well as telling me to select "Yes" or "No" from dropdown list in column K.
Test the uploaded file and see if you can step through the macro now.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks