Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel course in london - User defined range in Excel

excel course in london - User defined range in Excel

ResolvedVersion Standard

Tue 21 Aug 2007, 12:13 Delegate Ian said...

Ian has attended:
Excel VBA Intro Intermediate course

User defined range in Excel

Please confirm the coding required so that a formatting procedure I have written is only applied to the range selected by the user i.e. the user will select the range then run my VBA procedure via a button on their toolbar.

Thanks
Ian

Tue 25 Sep 2007, 10:59 Trainer Anthony said...

RE: User defined range in Excel

Hi Ian. As long as you are using the ".Selection" identifier within your code, your procedures should only run on the range selected by the user.

Hope this helps,

Anthony

Tue 25 Sep 2007, 15:49 Delegate Ian said...

RE: User defined range in Excel

Hi Anthony

Thanks for your reply

Please could you give me an example of the code when the ".selection" identifier is used.

Thanks
Ian

Wed 24 Oct 2007, 13:53 Edited on Wed 24 Oct 2007, 13:53 Trainer Rich said...

RE: User defined range in Excel

Ian,

Sorry for the delay in replying - Anthony is on sabbatical.

Try: this page

Regards, Rich

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips

excel course in london - User defined range in Excel

User defined range in Excel

RE: User defined range in Excel

RE: User defined range in Excel

RE: User defined range in Excel

Excel articles

Excel tip:

Move or Highlight Cells