Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use an entire row as "recordset"
Please can someone assist me with this as I usually program in access and I'm
struggling with the VB in excel. From a button_click procedure, I need to set the last row inserted in "Sheet1" as a recordset in order to use the different values in various cells in "Sheet2". e.g Dim rs as recordset in Access. I would like to say something to the effect of: Find the last record inserted (the last row on the sheet): eg: Set rRng = Range("A3:A" & Range("A" & Rows.Count).End(xlUp).Row), but for the entire row. Then I need to be able to say something like: Set Sheet2 C10 = rs!sheet1 B3 ANY assistance would be greatly appreciated. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Excel 97 ADODB Recordset.Find "Invalid Use" error | Excel Programming | |||
Copy recordset from an Access "make table" query | Excel Programming | |||
Creating small "recordset" or sorting a numeric 1-dim array | Excel Programming |