Finding last cell with data in a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel Bennett - 28 Apr 2005 14:23 GMT

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

Reply to this Message

anonymous@discussions.microsoft.com - 29 Apr 2005 17:59 GMT

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

>-----Original Message-----
>I am looking for something that will find the last cell of
[quoted text clipped - 16 lines]
>Thanks
>.

Reply to this Message

zackb - 29 Apr 2005 20:03 GMT

You may also want to look here:

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.

Signature

Regards,
Zack Barresse, aka firefytr

>I am looking for something that will find the last cell of
> data in a column, here is what I want to do
[quoted text clipped - 14 lines]
>
> Thanks

Reply to this Message

Rate this thread: