Range with R1C1 format

**one8421** · 01-22-2009, 11:12 PM

Why can't I use the following formula in VB? How can this be solved?

Please Login or Register  to view this content.

It seems to me that we can't use R1C1 expression in range. Anyway to go around it?

**jasoncw** · 01-22-2009, 11:18 PM

Please wrap your code in CODE tags per the forum rules. And there is nothing wrong with the code you posted above; it can be used in VBA.

Jason

**royUK** · 01-23-2009, 03:16 AM

I have added code tags, make sure you read & follow the forum rules in future.

There's nothing wrong with your posted code.

**mudraker** · 01-23-2009, 06:47 AM

Whilst the code you posted normally works I have seen several cases were it was necessary to add the Address command to the Cell command

Please Login or Register  to view this content.

**Richard Schollar** · 01-23-2009, 07:01 AM

Hi

You have unqualified sheet references which will cause you problems if the Activesheet is different from Sheet1. You need:

Please Login or Register  to view this content.

Note the periods (.) before the Cells().

Richard