excel course in london - User defined range in Excel

Resolved · Low Priority · Version 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...