| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a formula into the last row of a cell
I think its some like this:
With currentWorkbook Set Lastrow = Sheet1.Range("a65536").End(xlUp) 'write the data to the new sheets Lastrow.Offset(1, 0) = surveyWorkbook.Name Lastrow.Offset(1, 1).Formula = "surveyWS!b4" Lastrow.Offset(1, 2).Formula = "surveyWS!b5" End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert text from one cell into formula in another cell. | Excel Discussion (Misc queries) | |||
| Insert Formula in Cell with VBA | Excel Programming | |||
| Using VBA to Insert a formula in a cell | Excel Programming | |||
| Insert value of formula into cell | Excel Programming | |||
| insert formula in last cell | Excel Programming | |||
Hybrid Mode
