Need Assistance Tweaking VBA (last row / column)

[sparkytech]

I have the following generic code to find the bottom row and last columns. I need to change this to find the last row containing data, and to specify specific columns instead of all. Can someone guide me? Thanks!

BotR = MasterWS.Cells.Find(What:="*", After:=Range("A1"), LookAt:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row

LastC = MasterWS.Cells.Find(What:="*", After:=Range("A1"), LookAt:=xlPart, LookIn:=xlFormulas, SearchOrder:=xlByColumns, SearchDirection:=xlPrevious, MatchCase:=False).Column

 

[gordsky]

this will give you the lastrow with data in it on the sheet and the lastcolumn with data in it

lrow = ActiveSheet.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

lcol = ActiveSheet.Cells.Find("*", SearchOrder:=xlBycolumns, SearchDirection:=xlPrevious).column

when you say specify specific columns what do you mean? In your search range or return the specific column that the last row of data is in?

 

[sparkytech]

this will give you the lastrow with data in it on the sheet and the lastcolumn with data in it

lrow = ActiveSheet.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

lcol = ActiveSheet.Cells.Find("*", SearchOrder:=xlBycolumns, SearchDirection:=xlPrevious).column

when you say specify specific columns what do you mean? In your search range or return the specific column that the last row of data is in?

Thanks for the code! What I meant by specific columns, is that I want it to only search column A to Y.

 

[gordsky]

Where your code has "Cells" replace it with the range ie

lrow = ActiveSheet.Range("A:Y").Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row