Thread: Problem with sendkey method
View Single Post
 
Old 06-03-2024, 06:45 PM
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
You shouldn't need SendKeys. Do either of these lines do what you wanted?
Code:
Selection.ShowPrecedents
'or
Selection.DirectPrecedents
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote