Finding last cell with data in a column
 

I am looking for something that will find the last cell of
data in a column, here is what I want to do

the function I have is

=if(a1=0,0,(b1-$cS10)*d1)

C10 is the total for that column

now that works fine on sheet 1 but on sheet 2 and then
sheet the total is in cell C23, due to the nature of the
spreadsheets I am coding it so the formulas get entered
each time by clicking a button. How do I find the last
cell containing data in column C and then use it in the
formula. Once I can find it on one sheet then I can find
it on the rest

Thanks

http://www.xldynamic.com/source/xld.LastValue.html#vba

-----Original Message-----
I am looking for something that will find the last cell
of
data in a column, here is what I want to do

the function I have is

=if(a1=0,0,(b1-$cS10)*d1)

C10 is the total for that column

now that works fine on sheet 1 but on sheet 2 and then
sheet the total is in cell C23, due to the nature of the
spreadsheets I am coding it so the formulas get entered
each time by clicking a button. How do I find the last
cell containing data in column C and then use it in the
formula. Once I can find it on one sheet then I can find
it on the rest

Thanks
.

You may also want to look he

http://www.vbaexpress.com/kb/getarticle.php?kb_id=417

http://www.vbaexpress.com/kb/getarticle.php?kb_id=418

You can disregards everything except the functions 'xlLastRow' and
'xlLastCol'.

Although I'd suggest changing one line in each UDF ..

WorksheetName = ActiveSheet.Name

... change to ..

WorksheetName = Application.Caller.Parent.Name

This ensures that the function will work in the worksheet setting and not
just in the VBA environment.

--
Regards,
Zack Barresse, aka firefytr

"Nigel Bennett" wrote in message
...
I am looking for something that will find the last cell of
data in a column, here is what I want to do

the function I have is

=if(a1=0,0,(b1-$cS10)*d1)

C10 is the total for that column

now that works fine on sheet 1 but on sheet 2 and then
sheet the total is in cell C23, due to the nature of the
spreadsheets I am coding it so the formulas get entered
each time by clicking a button. How do I find the last
cell containing data in column C and then use it in the
formula. Once I can find it on one sheet then I can find
it on the rest

Thanks