Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
filling a forumla down a column from data across a row | Excel Worksheet Functions |