Is there any way to activate Intellisense such that it only shows relevant parameter values?
For instance, if I write the following, I'd like to know what the possible values are for the parameter "CopyOrigin". Nothing pops up by default, but if I press Ctrl+J a long drop-down list will appear. This is somewhat useful, but the vast majority of values in the drop-down list are irrelevant/invalid for this parameter.
I've also attached a screenshot for your reference.![]()
rng.EntireRow.Insert Shift:=xlShiftDown, CopyOrigin:=...
IntellisenseQuestion.png
Bookmarks