• WSalexanderd

    WSalexanderd

    @wsalexanderd

    Viewing 15 replies - 91 through 105 (of 133 total)
    Author
    Replies
    • in reply to: nested ‘ IF ‘ more than 7x (officexp 2002) #749657

      this is becoming serious an i am greatfull for all the input i agree that using
      wsh.Range(“P4”).Formula = _
      “=IF(OR(A4=33070,A4=33080,A4=33085,A4=33087,A4=33090,A4=33091,A4=33093,A4=33094,A4=33095,A4=33097,A4=33099,A4=ect ect dose work and at present i have reached a maximum of 29 items but to a slowing down of the end result.
      i am now going to split this in half and see if it makes a difference.
      Steve Aprahamian reply of 23 july is much quicker but as yet i have not found a way to call up the sub from in the main programe.
      still trying to achieve a better product for all to use.

    • in reply to: nested ‘ IF ‘ more than 7x (officexp 2002) #748004

      i am sorry i have taken so long to reply to you, but other projects have placed this one on the back burner.
      if i use the code as a separate public sub all works ok, what i am having difficulties with now is being able to ” call DeleteBad ” from within my main programme. which unfortunately stops part way through the “Function DeleteMe” at “Ubound” have you any advise on this

    • in reply to: nested ‘ IF ‘ more than 7x (officexp 2002) #748005

      i am sorry i have taken so long to reply to you, but other projects have placed this one on the back burner.
      if i use the code as a separate public sub all works ok, what i am having difficulties with now is being able to ” call DeleteBad ” from within my main programme. which unfortunately stops part way through the “Function DeleteMe” at “Ubound” have you any advise on this

    • in reply to: offset and font change (excel 2002) #743732

      my greatfull thanks to all who have contributed to answering my cry for help. your suggestion works a treat and the comments made by your self will be acted upon.
      for any one who is interested the reason for the program is a fail safe devise. i work for a wholesaler who delivers orders when the value of the order reaches a given value. i try to stop those accounts who fall short by less than 10% from not getting there order delivered.

    • in reply to: offset and font change (excel 2002) #743733

      my greatfull thanks to all who have contributed to answering my cry for help. your suggestion works a treat and the comments made by your self will be acted upon.
      for any one who is interested the reason for the program is a fail safe devise. i work for a wholesaler who delivers orders when the value of the order reaches a given value. i try to stop those accounts who fall short by less than 10% from not getting there order delivered.

    • in reply to: offset and font change (excel 2002) #743193

      i have resent the attachment and this time not cut out as much as last time (100K limit)

      as you have found out the subtotals which are hilighted in red uses the full range (G4:G1500) before it exits.
      i would like it to exit after it finds the last subtotal which could be only 2 or 100 subtotals and could have the last subtotal on row 1000 or on row 50
      your patience and help are much appreciated.

    • in reply to: offset and font change (excel 2002) #743194

      i have resent the attachment and this time not cut out as much as last time (100K limit)

      as you have found out the subtotals which are hilighted in red uses the full range (G4:G1500) before it exits.
      i would like it to exit after it finds the last subtotal which could be only 2 or 100 subtotals and could have the last subtotal on row 1000 or on row 50
      your patience and help are much appreciated.

    • in reply to: offset and font change (excel 2002) #743187

      my apologies i tried to save to much ie less than 100k

    • in reply to: offset and font change (excel 2002) #743188

      my apologies i tried to save to much ie less than 100k

    • in reply to: offset and font change (excel 2002) #743148

      please run the first macro( it is quite safe ) takes approx 1 minute to run but is changes the results once i trty to save them

    • in reply to: offset and font change (excel 2002) #743147

      please run the first macro( it is quite safe ) takes approx 1 minute to run but is changes the results once i trty to save them

    • in reply to: offset and font change (excel 2002) #743105

      attached is a zip file with my clumsy macro (which works for me in approx 100 seconds)

    • in reply to: offset and font change (excel 2002) #743106

      attached is a zip file with my clumsy macro (which works for me in approx 100 seconds)

    • in reply to: offset and font change (excel 2002) #742708

      only the subtotals are shown under the alloc column running the macro changes the font to bold
      if you prefer i can send an excel file

    • in reply to: offset and font change (excel 2002) #742709

      only the subtotals are shown under the alloc column running the macro changes the font to bold
      if you prefer i can send an excel file

    Viewing 15 replies - 91 through 105 (of 133 total)