| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
specify a range of cells for data input, down then over
A program automatically sends data to an excel spreadsheet everytime a
measurement is taken (a wedge program). The cell the data is placed in is based on the cell that is currently highlighted/active. I want to create a range of cells (5x25) where when data is sent, it places the first value in A1, then B1, then C1, etc... When it gets to E1, I want it to continue at A2, B2, C2, etc. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
specify a range of cells for data input, down then over
Sub test()
ActiveCell.Resize(25, 5).Select For Each c In Selection 'this loop is jumping thrue the selected range the way u want Next End Sub "jmirer" skrev: A program automatically sends data to an excel spreadsheet everytime a measurement is taken (a wedge program). The cell the data is placed in is based on the cell that is currently highlighted/active. I want to create a range of cells (5x25) where when data is sent, it places the first value in A1, then B1, then C1, etc... When it gets to E1, I want it to continue at A2, B2, C2, etc. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why input range contains non-numeric data? | Excel Discussion (Misc queries) | |||
| Select a range of data dependant on the users input ie dates | Excel Discussion (Misc queries) | |||
| sheet protection - only selected range to be able to select/input data | Excel Worksheet Functions | |||
| How can I run a spreasheet over range of input data ? | Excel Discussion (Misc queries) | |||
| How can I set a input range for entrying data. | Excel Worksheet Functions | |||
Linear Mode
