| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
last row of sheet1 to use in a formula in sheet2
You were right and the answer is perfect. As for the other, this is me not
typing well. SLRow and LRow should have been the same. Thank you for your help and patience. This forum is an oasis in a desert. "Dave Peterson" wrote: Just a typo that was in the original that was carried over in your response: Range("A1:E(" & SLRow & ")") should be: Range("A1:E" & SLRow) or Range("A1:E" & LRow) I'm know that the ()'s shouldn't be there. I'm confused by the SLRow/LRow stuff, though. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| need a formula to transpose sets of data from Sheet1 to Sheet2 | Excel Discussion (Misc queries) | |||
| formula-add 2 numbers of cell a1 and a2 of sheet1 ans-b9in sheet2 | Excel Worksheet Functions | |||
| Add a formula to sheet2 for to each nonempty line in sheet1 | Excel Programming | |||
Threaded Mode
