Thread: [Solved] Using If Then with Bookmarks to specify text
View Single Post
 
Old 08-26-2020, 03:44 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
I missed adding .Range on the end of that line. Try altering it to read

Set oRng = .Bookmarks(sName).Range
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote