Command Button - Select Range

[jonhfl]

Hi,

I am having trouble making a command button on a worksheet select a new worksheet and range. The code is below...

Please Login or Register  to view this content.

or a longer way

Please Login or Register  to view this content.

Both of these create errors. If I take off the range selection I can get to the sheet.

But how can I make it select the range also?

Thank you.

[JBeaucaire]

The big question is why are you trying to select a cell with VBA? There are few reasons to actually select a cell prior to doing something in/to that cell. If you wanted to put a value in a particular cell on a particular cell, just do it directly without selecting first:

Please Login or Register  to view this content.

If you've learned to "select" from looking at macro recorder code, that's the first thing that should be edited out of all recorded code. The recorder records what we humans are doing step by step, not the right way to do it. Code is far more efficient once all the selecting is taken out and commands are issued directly the cells/ranges.

[Leith Ross]

Hello jonhfl,

To activate the worksheet and the make the cell you want the active cell, you can use Application.GoTo. The Scroll argument will place the cell in the upper left hand corner of the worksheet when true. Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.

Please Login or Register  to view this content.