Problem with Multiple Ranges

[Paul Sheppard]

I am using excel 2000

I have a spreadsheet into which sales data is enterred, for a range of cells e120:e138, named xEuro, the data is enterred as euros and automatically converts to £

The code is as follows:

Please Login or Register  to view this content.

I now want to extend the range, to include 12 columns of data, but get an error message "Compile error wrong number of arguments or invalid property assignment" when I have more than 2 columns in the range

The code I have tried is as follows:

Please Login or Register  to view this content.

What do I need to change to be able to add multiple ranges

Thanks in advance for any help

Paul

[jonn]

Have you tried that?

Please Login or Register  to view this content.

[Paul Sheppard]

Have you tried that?

Please Login or Register  to view this content.

If I use the above any entries in columns between E and K will cahnge when I only want E and K to change

[mudraker]

use

Please Login or Register  to view this content.