Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
autofilter/cell selection problems
Hello,
I have a little program that needs to run on a sheet that has multiple user information on it. The users go in and use the auto filter funtion so that they only view the information important to them. When this program runs and they select the cells they want (They often drag the mouse over a range that may have hidden ranges within it) the program selects hidden cells aswell. Is there a way that it will only select the ranges that are selected and viewable: Here is the code I'm using for this section of the program: Dim rCells As Range Dim rRange As Range Dim rstart As Range Dim ireply As Integer Dim strStart As String On Error Resume Next 'Let the user choose the cells with the drawings that will appear on the Draw. Ack. Set rCells = Application.InputBox _ (Prompt:="Select the drawings you wish to appear on the Drawing Acknowledgement", _ Title:="Create Drawing Acknowledgement", Left:=558, Type:=8) For Each rRange In rCells... Thanks, Jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell selection problems in Excel | Excel Discussion (Misc queries) | |||
Chart Title Using Autofilter Selection | Charts and Charting in Excel | |||
Problems using autofilter | Excel Discussion (Misc queries) | |||
How do I save an autofilter selection as a new file? | Excel Worksheet Functions | |||
Paste into autofilter selection! | Excel Worksheet Functions |