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


--
Jclout
------------------------------------------------------------------------
Jclout's Profile: http://www.excelforum.com/member.php...o&userid=33267
View this thread: http://www.excelforum.com/showthread...hreadid=530925

This may help you

http://www.ozgrid.com/VBA/ExcelRanges.htm

"Jclout" wrote:


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


--
Jclout
------------------------------------------------------------------------
Jclout's Profile: http://www.excelforum.com/member.php...o&userid=33267
View this thread: http://www.excelforum.com/showthread...hreadid=530925