I've given it a little thought too. The chart I have on the screen:
A A# B C C# D D# E F F# G G#
A# B C C# D D# E F F# G G# A
B C C# D D# E F F# G G# A A#
C C# D D# E F F# G G# A A# B
C# D D# E F F# G G# A A# B C
D D# E F F# G G# A A# B C C#
D# E F F# G G# A A# B C C# D
E F F# G G# A A# B C C# D D#
F F# G G# A A# B C C# D D# E
F# G G# A A# B C C# D D# E F
G G# A A# B C C# D D# E F F#

I created some time ago to use manually to trans pose a song. Say the
chords foir a song in C are C, F & G
Look at from top to bottom, you see C, F & G correspond to C#, F# & G# in
the next column, etc. That is how
I used it. But, for the purpose of creating a macro, what I think should
happen is each cord should be assigned a number
A=1, A#=2, B=3, C=4, C#=5, D=6 ... G=11. and when the macro is invoked, you
should be prompted to enter the key the song is in, say C and then you
should
be prompted as to what key you want it transposed to, say D and then the
macro would go through all the chords in the song, and somehow add 2 (not
sure if that is the way to say that) to each one, because D is 2 numbers up
from A and replace eacht chord with the new one that is 2 up from it, so
that C, F and G become, would now be D, G and A. I have no idea how to do
this. I am not a programmer and don't know how to write macros at all. I
can reverse engineer them -- that is if you send me a formual, or a bit of
macro code, I can see what the result is and then be able to use it when
needed, but understand it? Not yet. The macro would probably use search and
replace somehow, but it would have to ignore everything in the lines with
the lyrics somehow. Another thing is that our current setup is fairly week,
because it only includes, major, 7th, minor and 9th chords. Say the chords
of the song are already in place above the lyrics and a A, b7, Bflat
diminished, C+ (augmented). We would want the macro only to deal with
replacing the letter A, B and c, so changing the key one step up would give
us A# C7, B diminished, C#+.
Ross


"Ken Johnson" wrote in message
oups.com...
Ross,
I've never done it but I'm sure it could be done since transposing is
just applying rules to the chord pattern. You've got me thinking now,
trouble is fast thinking's not my forte.
Do you plan on somehow using the table you have on the worksheet?
That's a key transposition table I think.