Log in

View Full Version : Alignement forcolumns in a Power point tabel



aoucharla
08-06-2014, 01:03 AM
Hi,

I need the VBA code for the aligning my cell Contents similar to the cells marked in green color.
Actually these are 3 columns which are merged together and with in the merged column they have 3 different column names with 3 different alignments. Please suggest

12061

John Wilson
08-06-2014, 06:02 AM
It's impossible to see your image - it is far too small. Also I don't think it's possible for "columns" in a merged cell to have different alignments (paragraphs can)

aoucharla
08-06-2014, 06:37 AM
It's impossible to see your image - it is far too small. Also I don't think it's possible for "columns" in a merged cell to have different alignments (paragraphs can)

Hi,

I have explained the reqirement in the attached document.
Please suggest

John Wilson
08-06-2014, 08:31 AM
And as I said I don't think that is possible using alignment. Are you able to do it manually in a merged table? (without tabs or spaces) You might be able to achieve by instead setting the grid lines to none (though sadly there's a bug which does not allow this in code.)

aoucharla
08-06-2014, 09:05 AM
And as I said I don't think that is possible using alignment. Are you able to do it manually in a merged table? (without tabs or spaces) You might be able to achieve by instead setting the grid lines to none (though sadly there's a bug which does not allow this in code.)

hi John,

THanks for your response.
Can you suggest an alternate way of achieving this. yes you are right i am not able to do it without spaces and tabs in a merged cell.

John Wilson
08-06-2014, 09:19 AM
The only way would be to make it look like a merged cell by (manually) setting some lines to none.