Find first empty cell in row range-VBA

[ljubo_gr]

=Happy+New(Year(2017))

I have three sheets, they have columns A&B, ranges A2:A100, B2:B100. "A" range will always be shorter than B, if that means something. I need vba code to move my selector to First free cell in sheet1 "A"range, another code for "B"range, then another codes for Sheet2...Sheet3.
Thanks in advance kind people!

 

[ljubo_gr]

it highlights the row of a selected cell between range: A2:U721, i think they cannot be in ThisWorkbook together? I must put Michael+s code inside a module, but then it will not work for those three sheets with different ranges

 

[Michael M]

Change your arrow codes to

Sub upArrow()
Thisworkbook.activesheet.Range("B7:B" & Cells(Rows.Count, "B").End(xlUp).Row).Find(What:="", lookat:=xlWhole).select
End Sub

Sub DownArrow()
Thisworkbook.activesheet.Range("P7:P" & Cells(Rows.Count, "P").End(xlUp).Row).Find(What:="", lookat:=xlWhole).select
End Sub

Which should be in thisworkbook module and will apply to the activesheetsheet

Because you have different ranges in each sheet....that's why I suggested the InputBox Method !!!

 

[ljubo_gr]

Change your arrow codes to

Sub upArrow()
Thisworkbook.activesheet.Range("B7:B" & Cells(Rows.Count, "B").End(xlUp).Row).Find(What:="", lookat:=xlWhole).select
End Sub

Sub DownArrow()
Thisworkbook.activesheet.Range("P7:P" & Cells(Rows.Count, "P").End(xlUp).Row).Find(What:="", lookat:=xlWhole).select
End Sub

Which should be in thisworkbook module and will apply to the activesheetsheet

Leave it in ThisWorkbook?

 

[Michael M]

Did you read the entire message I Posted......???

 

[ljubo_gr]

 

[svendiamond]

You can put the code in its own separate module

 

[ljubo_gr]

You can put the code in its own separate module

 

[ljubo_gr]

Bump?

 

[Michael M]

CAn't see the highlighted line....but the code works fine for me.
CAn you upload the workbook to Dropbox and then post the link back here ???

 

[ljubo_gr]

In here question; http://www.mrexcel.com/forum/excel-questions/982918-code-wont-clear-cache.html

Thank you so much Michael!
please, try code on sheet "ED-5" or "LOŽ ULJE" or "BMB-95", code is in module12 i think...