| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering formula using cells notation
Hi - I am trying to write the following in a macro in excel
For k = 8 to 1000 ........ For l = 1 To 50 If Cells(k + l, 2) < "" Then Cells(k + l, 19).Formula = "=cells(k+l,19)/cells(k,19)" - does not work in xls Cells(k + l, 20).Formula = "=A1/B2" - works in xls End If Next .......... Can anyone suggest how to do this in loops? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering dates into cells as mm/yy or yy | Excel Discussion (Misc queries) | |||
| Entering Times in Cells | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Entering text in cells | Excel Discussion (Misc queries) | |||
| Entering zeros in cells | Excel Discussion (Misc queries) | |||
Threaded Mode
