-
Aug 1st, 2013, 11:49 AM
#1
Thread Starter
Junior Member
dynamic min formulae (column changes)
All,
Following formula gives me an application defined or object defined error:
ActiveCell.FormulaR1C1 = "=min(R" & rowr & "C" & week2locform & ":R" & rowr & "C)"
whereby rowr = 2 (will not change)
week2locform = -10 (will change)
The Column on the end is correct at being assigned to 0- i.e. the end of the min formulae is in a cell 2 rows above but in the same column.
Any help would be much appreciated...
Thanks
Inderpal
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|