Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a program for which I need to have the users select the cells they want. Right now I am using: Set rCells = Application.InputBox _ (Prompt:="Select the drawings you wish to appear on the Drawing Acknowledgement", _ Title:="Create Drawing Acknowledgement", Left:=558, Type:=8).SpecialCells(xlCellTypeVisible) This works great, except that if the user clicks the start button and then needs to scroll down to select cells that they want, the program adds all the cells (starting on the first cell of the page, A1) that the user did not select. Hopefully this is a dumb error on my part, thanks, Jordan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA selecting an input range of cells | Excel Discussion (Misc queries) | |||
Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions |