| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Select
Hello
I have a spreadsheet where the first 15 rows are blank and then my data starts. I have freeze panes on I want to display information from the current row that has the cursor For example: My cursor is on row 21, I want to display the data from that row, say cell AD21 in cell A2 I think I just need the syntax to display the current ro range("A2").value = ???? current row Thank |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Select
You may be looking for:
Range("A2") = ActiveCell -- Vasant "Syr Doug" wrote in message ... Hello, I have a spreadsheet where the first 15 rows are blank and then my data starts. I have freeze panes on. I want to display information from the current row that has the cursor. For example: My cursor is on row 21, I want to display the data from that row, say cell AD21 in cell A2. I think I just need the syntax to display the current row range("A2").value = ???? current row Thanks D |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Select
Thanks for the reply, not quite. I know about Active Cell. I need more the current row
This will be pretty much static Cell A1 = I will need the data value of the AD + currentro Cell B1 = I will need the data value of the AE + currentro Cell A2 = I will need the data value o fhte AF + currentro |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Select
"Syr Doug" wrote in message
... Thanks for the reply, not quite. I know about Active Cell. I need more the current row This will be pretty much static. Cell A1 = I will need the data value of the AD + currentrow Cell B1 = I will need the data value of the AE + currentrow Cell A2 = I will need the data value o fhte AF + currentrow you mean something like ActiveCell.Row so maybe [A1].Value = Cells(ActiveCell.Row, 30) '30 is column AD [B1].Value = Cells(ActiveCell.Row, 31) '30 is column AE [A2].Value = Cells(ActiveCell.Row, 31) '30 is column AF Paul D |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Select
Sorry, I misunderstood. If you always want the data from column AD then try:
Range("A2") = Range("AD:" & ActiveCell.Row) -- Vasant "Syr Doug" wrote in message ... Thanks for the reply, not quite. I know about Active Cell. I need more the current row This will be pretty much static. Cell A1 = I will need the data value of the AD + currentrow Cell B1 = I will need the data value of the AE + currentrow Cell A2 = I will need the data value o fhte AF + currentrow |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Select
Paul
Exactly what I was looking for. Thank Dou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Select other workbook to select data in a macro. | Excel Programming | |||
Linear Mode
