Thanks TOM : That's what I was looking for.On 2002-04-24 01:05, TsTom wrote:
Sheet1.Range("A1") = "Put Some Text Here"
Is that it?
Tom
Yes that works.But the size of my columns are changed.What I want is to keep the size of the columns and that the date is displayed over 2 or 3 columns.On 2002-04-24 01:27, Mudface wrote:
Would this do?
Sheet1.Range("A1") = "Put Some Text Here"
Columns("A").Autofit
Many thanks.It works like I want.On 2002-04-24 01:49, Mudface wrote:
If there's nothing in the column next to it, and your horizontal alignment is set to General then it should appear over a few columns.