Jumping to intermittent last cells in a column

[rameshad]

HI Everybody -

Pl guide me to find intermittent last empty cell of a column, in column B need to find last intermittent cells ex:B234, B445,B561 ......

Enclosed excel sheet.

Thanks in advance,

Best,

Ramesha

[macropod]

Cross-posted at: https://www.mrexcel.com/forum/excel-questions/1066678-get-intermittent-last-cell-column.html
Please read VBA Express' Cross-Posting policy in rule 3: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3

[rameshad]

:help I, didn't know that, we need to paste link of questions posted in other forum, as no body had viewed the post in this forum, I, tried checking with other, will take note of your suggestion

[macropod]

no body had viewed the post in this forum
Exactly what do you expect from a volunteer forum on a weekend (given the time at which you posted, what's more)???

[rameshad]

very valid point, :think::think::bow::bow:

[Aussiebear]

"as no body had viewed the post in this forum"....

Unfortunately you posted this in the "Announcements" forum rather than the "Excel" forum

[p45cal]

Pl guide me to find intermittent last empty cell of a column, in column B need to find last intermittent cells ex:B234, B445,B561 ......…and do what with them?
The following acts on the active sheet and puts a link to them in a list starting at cell M1 of that active sheet.
Sub blah()
Set Destn = Range("M1")
For Each are In Columns("B:B").SpecialCells(xlCellTypeConstants, 1).Areas
Destn.Formula = "=" & are.Cells(are.Cells.Count).Address
'ActiveSheet.Hyperlinks.Add Anchor:=Destn, Address:="", SubAddress:=are.Cells(are.Cells.Count).Address 'this line, if uncommented also adds a link to that cell.
Set Destn = Destn.Offset(1)
Next are
End Sub