Computing.Net > Forums > Programming > Excel Macro

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Macro

Reply to Message Icon

Name: AlwaysWillingToLearn
Date: November 1, 2006 at 08:05:14 Pacific
OS: winxp
CPU/Ram: 512
Product: none
Comment:

hello,

i am writting a macro in Excel, i have a merged cell C43 and C44, now in my code i want to unlock this merged cell but i get an error, how do i reference a cell which has been merged?

Thanks,



Sponsored Link
Ads by Google

Response Number 1
Name: AlwaysWillingToLearn
Date: November 1, 2006 at 08:10:53 Pacific
Reply:

Dont panic i have figured it out

sheet4.range("C43:D43").locked=true

thanks,



0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Excel Macro

Can I call an Excel macro from cell www.computing.net/answers/programming/can-i-call-an-excel-macro-from-cell/4812.html

Excel macro www.computing.net/answers/programming/excel-macro/9408.html

Excel Macro www.computing.net/answers/programming/excel-macro/14702.html