Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Single Range for Multiple Operations
Hi Experts,
1. I let the user select a row as range using (Set EndCell = Application.InputBox("Select the range/cells",Type:=8) 2. Suppose user selects Row#3 in the foll example: ColA ColB ColB ColD ColE Row1 5 7 8 6 8 Row2 7 5 7 4 0 Row3 5 6 7 9 10 Row4 4 4 4 3 2 I want to use value 5 under ColA for calculation 1 I want to use value 6 under ColA for calculation 2 I want to use value 7 under ColA for calculation 3 I want to use value 9 under ColA for calculation 4 I want to use value 10 under ColA for calculation 5 How do I use the values of one row and different columns for different calculations? Without prompting the user to select value of Row3 and columnA for calculation 1 and so on... Thanks in advance for your great help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
How to return a single value for a range of numbers | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Protecting single cells or a range | Excel Discussion (Misc queries) | |||
Identifying single column within named range | Excel Discussion (Misc queries) |