Need help with simple VBA problem

[sparkytech]

I have the code below checking for last row / column. How can I change this to manually set the last column to "AB" rather than the last column of the table?

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

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

 

[Fluff]

How about

LastC = 28

 

[sparkytech]

How about

LastC = 28

Beautiful, thanks! Still learning VBA, appreciate the assistance!

 

[Fluff]

You're welcome & thanks for the feedback.