Steve001
Board Regular
- Joined
- Apr 13, 2017
- Messages
- 86
- Office Version
- 365
- 2021
- 2013
- Platform
- Windows
Hi All,
Bit stuck with this one..
How do i set a forumla into a cell using variables
Example
=MIN(Colum, Row : Colum, last row)
I am trying to use something like this
Cells(Row, Colum).Formula = "=MIN(" & Cells(firstrow & ":" & last)
but get errors
Steve
Bit stuck with this one..
How do i set a forumla into a cell using variables
Example
=MIN(Colum, Row : Colum, last row)
I am trying to use something like this
Cells(Row, Colum).Formula = "=MIN(" & Cells(firstrow & ":" & last)
but get errors
Steve