Select sheet and range at once

**Jiptastic** · 05-09-2013, 01:38 PM

Hmm. It definitely doesn't work for me, capitol letter or not, unless I am already on Sheet1.

**HaHoBe** · 05-09-2013, 01:55 PM

Hi, Jiptastic,

why don´t you use

Application.Goto Reference:=Sheets("Sheet1").Range("A1")

Ciao,
Holger

**WasWodge** · 05-09-2013, 01:59 PM

Are you getting an error message?
What happens if you run

Sheets("Sheet1").Range("A1").Value = "111"

**HaHoBe** · 05-09-2013, 02:04 PM

Hi, WasWodge,

if you´re not on the sheet and run your code RTF 1004 should show up - not with my sample though.

Ciao,
Holger

**WasWodge** · 05-09-2013, 03:50 PM

Hi, WasWodge,

if you´re not on the sheet and run your code RTF 1004 should show up - not with my sample though.

True. That's what comes of replying from your phone without testing. I was probably on the same sheet when I replied the other day. Apologies

P.S. could have done with an embarrassed smiley

Re: Select sheet and range at once