Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting & VBA (Excel 2000 SR1/ Win 95)

    I am trying to cut and paste a range of cells with conditional formatting in a VBA macro. On some PC I am using this owrks fine. However on other I get a VBA error saying " Run time error -2147417848 (80010108) Method ' Paste' of object '_Worksheet' failed". This relates to MSKB article Q231144. What I would like to know is how can I tell which versions/SR's of Excel this relates to ?
    Does anyone else have any experience of this ?

    In anticipation,

    PaulJ

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting & VBA (Excel 2000 SR1/ Win 95)

    As the Article does not mention Service Release information, we can assume that it is a problem with all SR's, as II think MS would advise if the problem was fixed by a particular SR.

    Have you tried the suggested workaround, and did it work ?

    Andrew C

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting & VBA (Excel 2000 SR1/ Win 95)

    Andrew,
    It's not the workaround that bothers me but the fact that on some PCs I have successfully recorded a VBA macro to cut and paste the range with the conditional formatting but on others it causes Excel to hang. Both are running Excel 2000 (Version 9.0.3821) SR-1. I am concerned about the implications for sharing VBA code.

    PaulJ

Posting Permissions

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