View Single Post
 
Old 09-26-2022, 10:32 AM
Stephen Ray Stephen Ray is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Sep 2018
Location: Kansas
Posts: 34
Stephen Ray is on a distinguished road
Default

Macropad, I found a work around.
I selected and highlighted the date in the last paragraph: 9/22/2022 10:36:45 AM
Then I used this: Set oRng = Selection.Range
That works.

But if you can find a way to do it using "Last" Please let me know.
And where the devil can I read about all the ways to use Range?

Somebody like you should write a book and make lots of money.
We really do need somebody to write a book with VBA syntax with lots and lots of examples.

The best way to learn any language is by reading good literature.
Reply With Quote