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
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
Cross-posted at: https://www.mrexcel.com/forum/excel-...ll-column.html
Please read VBA Express' Cross-Posting policy in rule 3: http://www.vbaexpress.com/forum/faq...._new_faq_item3
Cheers
Paul Edstein
[Fmr MS MVP - Word]
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
very valid point,
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
…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
Last edited by p45cal; 08-21-2018 at 08:07 AM.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.