Trying to set a range

Question

  Set rng = ActiveSheet.(D4:K57)

the following code throws "Expected: identifier or bracketed expression". What is the error here?

You haven't set the range properly, `ActiveSheet.range(D4:K57)` — Davesexcel, May 19 '15 at 14:57
Thanks! Although it worked when quotation marks were around D4:K57. — user3097236, May 19 '15 at 15:02
[Check this out to improve coding](http://stackoverflow.com/questions/10714251/) — L42, May 19 '15 at 22:14

score 0 · Answer 1 · answered May 19 '15 at 22:05

0

ActiveSheet.range("D4:K57")

Normally I would dim the range though,

Dim rng as range
set rng=range("D4:K57")

rng.select' or whatever you want to do with it

answered May 19 '15 at 22:05

Davesexcel

1 Answers1