View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Howard Brazee Howard Brazee is offline
external usenet poster
 
Posts: 68
Default VB macros in new Excel

On Mon, 04 Jan 2010 13:35:52 -0700, Howard Brazee
wrote:

Those cells would have a format of '12-5
or '12-5:1:2
or '12-5:1:2:C



Odd, this seems to work if column C doesn't have a colon. If the 2nd
option is in column d it works, but if it's in column c, I get an
error.

The following are my results in columns B, C, & D

179 9-7 12-4:3:0:C
M 13:3:0:1 11-5:1:0 9-7

This implies that there is a broken macro somewhere. I just need to
find it.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison