Microsoft Office Forums - View Single Post - [Solved] Using If Then with Bookmarks to specify text

Thread: [Solved] Using If Then with Bookmarks to specify text

View Single Post

Old

08-26-2020, 06:05 AM

RedZed1100 RedZed1100 is offline

RedZed1100 is offline

RedZed1100 uses Windows 10

Windows 10 RedZed1100 uses Office 2016

RedZed1100 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Aug 2020

Location: England

Posts: 8

RedZed1100 is on a distinguished road

Default

Quote:

Originally Posted by Guessed

View Post

I missed adding .Range on the end of that line. Try altering it to read

Set oRng = .Bookmarks(sName).Range

Thanks. It wasn't obvious -not to me anyway.

Reply With Quote