Offset text in merged cell

[juriemagic]

Hi,

I am struggling to "shift" text which are in a merged cell. The merged cell ranges from A1 to A3. I know I can centre-, left- or right-align text with vba, however I need to actually move the text into a different position which could be slightly more to the left or to the right from center position. Any help would be greatly appreciated!. Thanx a million!!

BURAN--Thanx a million!!..your idea worked!!!

[bulina2k]

Try adding some spaces after text. It will center the text with the spaces also.

[buran]

Using spaces is really bad idea.
check range.InsertIndent property and also Range.IndentLevel property

[bulina2k]

No, using merged cells and VBA is a really bad ideea. Spaces does't include VBA.

[buran]

what I mean is using spaces to align cell content, regardless the VBA. Period.
I more or less agree regarding merged cells and VBA.

[bulina2k]

naah, it's fast and easy and does the job.

[buran]

And sooner than later will bite you back when try to compare/search/replace/whatever in that cell content

[bulina2k]

I for one would try to avoid merging cells but if the situation asks, there's always TRIM function helping to compare/search/replace/whatever in that cell content...

[buran]

I for one would try to avoid merging cells but if the situation asks, there's always TRIM function helping to compare/search/replace/whatever in that cell content...

I already said I more or less agree on avoiding merged cells. However that's the other user's decision and it's not the point in that thread. Nobody asks about that.
If you don't see or pretend that you don't see the problem with with adding spaces to align cell content - good luck, feel free to use Trim, LTrim, RTrim as much as you wish in your code and have fun maintaining it.

[juriemagic]

Hi Buran,

I just wanted to let you know that the reason I needed EXACTLY what you gave me, is because the text in this cell needs to "shift" or glide inside this merged cell as different situations come up which will make other macro buttons become visible, and as a result will then cover the text. so the text needs to glide to the left..then later when the buttons are invisible and transparency is 1, the text needs to glide again back to the right.

thanx for your help..i really appreciated it...

[bulina2k]

THAT makes much more sense now!

[juriemagic]

yep..my apologies...

I normally just say what I need to happen, and don't normally go into a lot of detail...but maybe this was a learning curve for me...BE SPECIFIC!! http://www.excelforum.com/images/smilies/smile.gif

[juriemagic]

yep..my apologies...

I normally just say what I need to happen, and don't normally go into a lot of detail...but maybe this was a learning curve for me...BE SPECIFIC!!