My Cells C2 and D2 are merged. I am trying to input a variable into their cell. However I keep getting a problem.
I even tired changing the name of the cell in the 'Name Box' in the excel sheet from C2 to Name
Please Login or Register to view this content.
However, I get a merged cells error.Please Login or Register to view this content.
Any help would be appriciated thanks
Hey,
Merged cells (Grrrrrrr)
Do you need them merged?
If not try:
hope it helpsPlease Login or Register to view this content.
JR
Versions
Mac OS X 'Leopard'
Mac MS Office Excel 2004
Windows XP
MS Excel 2002
MS Excel 2003
Merged cells should always be avoided, use Centre across selection from the Format menu , under Cells.
Your code will not input a variable, but get the variable. This will show the difference, note it works if C2:D2 are merged.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank You
Worked PerfectlyPlease Login or Register to view this content.
That's Ok, but please take note about not Merged Cells, they are sure to cause problems eventually.
absolutly, stay well clear and spread the message.
I see far to many people with merged cells every day beacuse they think it looks 'nice & pretty' then they moan that thay cant figure out why their chart is not working properly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks