Sheets("Sheet2").Range("AA1") = "Note"

**dcburkejr** · 08-03-2012, 11:23 AM

This might have already been covered but I can't find it anywhere. Anyways, I get error 9. It works all the way to Z1 and if I try to input it to AA1 there is a problem.

Sheets("Sheet2").Range("X1") = "ShippingTerms"

- works.

Sheets("Sheet2").Range("AA1") = "Note"

-This does not.

**mike7952** · 08-03-2012, 11:29 AM

Is the worksheet protected? If so id say cells that the code work on are protected.

**carrob** · 08-03-2012, 11:29 AM

It works fine for me in a new workbook, can you attach your workbook? There is probably something in it that is preventing your code from working.

**dcburkejr** · 08-03-2012, 11:40 AM

I figured it out. I wasnt naming the worksheet and there was a problem. Thanks for the fast replys.

**carrob** · 08-03-2012, 11:47 AM

Glad it works, please mark your thread as solved. Click "Thread Tools" at the top and click "Mark Thread as Solved"

**Cutter** · 08-03-2012, 04:10 PM

@ dcburkejr

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.