Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2001
    Location
    Engerland
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Currency Format (97 SR-2)

    Hi

    I've created a macro that populates an array with currency values. These are in British Pounds on the source worksheet, however when I paste them onto a new worksheet when I am done with populating my array, these are formatted as US dollars and I am not able to change to pounds (even by manually attempting to format). Is there something I am missing? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Currency Format (97 SR-2)

    AdeH

    Why are you using an array? You know you can use a range, as an array.

    Is your array Dimed properly? Can you send us an example with dummy data, just to see what exactly you are trying to do?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Lounger
    Join Date
    May 2001
    Location
    Engerland
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency Format (97 SR-2)

    Wassim

    Managed to sort this. Changed dim statement to double instead of currency, then used a user-defined currency format, rather than the named "Currency" format. This seems to work fine.

    Thanks for your help anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •