J
Jclout
I'm looking to create a function to find the last blank cell on a
different worksheet and then enter the data.
This is a small idea of what I'm trying to do.
I have 2 cells that I enter cabinet sizes in Height and Width. I only
use the width to find the size of the door/doors. Now I want to be
anble to see my results in a cell. So I call the function
=doorsize(A21) but now I would like to have this fill in a form on the
order worksheet at the same time.
I think I would use something like this to find the first blank cell in
a range of cells.
Scell would be the startijng cell
Ecell would be the ending cell
Function Doorsize(Size, Scell, Ecell)
If Size > 24.125 Then
Doorsize = (Size / 2) - 0.125
Else
Doorsize = Size - 0.125
End If
Here is where I would put the search string and how to enter the data
End Function
Any help to point me in the right direction would be great.
I'm not afraid of reading and trying to figure it out my self.
Thank you
Just a newbie to Excell but a master capenter
Jclout
different worksheet and then enter the data.
This is a small idea of what I'm trying to do.
I have 2 cells that I enter cabinet sizes in Height and Width. I only
use the width to find the size of the door/doors. Now I want to be
anble to see my results in a cell. So I call the function
=doorsize(A21) but now I would like to have this fill in a form on the
order worksheet at the same time.
I think I would use something like this to find the first blank cell in
a range of cells.
Scell would be the startijng cell
Ecell would be the ending cell
Function Doorsize(Size, Scell, Ecell)
If Size > 24.125 Then
Doorsize = (Size / 2) - 0.125
Else
Doorsize = Size - 0.125
End If
Here is where I would put the search string and how to enter the data
End Function
Any help to point me in the right direction would be great.
I'm not afraid of reading and trying to figure it out my self.
Thank you
Just a newbie to Excell but a master capenter
Jclout