Excel Button select range

  • Thread starter Thread starter Randal
  • Start date Start date
R

Randal

Why does this work in a macro but not in the code for a button?
"Range("B3:C3").Select"
 
I'm betting that you changed worksheets:

Try something like:

with worksheets("othersheet")
.select
.range("b3:c3").select
....


If your code is for a command button from the controltoolbox tooblar on a
worksheet:

Then unqualified refences like the range refence in this example:

worksheets("othersheet").select
range("b3:c3").select

will refer to the worksheet that holds the code. (The same code in a general
module will use the activesheet.)

And you usually don't have to select the range before you do something with it.
Maybe just work on that range directly???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM / COUNT formula 3
using 2 different IF statements 2
Excel Run macro upon cell edit 0
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Copy Rows based on count of last row of another Column 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Excel Help to copy information from one row at a time to another sheet 1
Excel VBA - Problem with Closing Print Preview 0

Back
Top