Browse 549 attributed reviews, viewable separately for our classroom and online training

Details for Emma H

Emma H has participated in the following threads:

Added by Emma H on 13 May 2020 at 17:14

Hiya! Loving the course and trying to put it to use already.

I'm trying to use the technique in the Sub Copy_Paris_Total() with my own data and I'm having some trouble. Instead of using the worksheet name, I'm using the sheet codenames. So I simply have:

Sheet4.Range("C14", Range("C14").End(xlDown)).Copy

Sheet1.Range("N1").Paste

However, unless I have selected the sheet being referenced by the code, I get an error: Select method of Range class failed. Is this because I've used the codenames?

Added by passerby on 26 Sep 2020 at 17:41

Wasn't aware of the survey, I'd vote for Python only.