Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to clear contents of a merged cell, Excel 2000 VBA ? 2

Status
Not open for further replies.
vamoose

vamoose

Programmer
Oct 16, 2005
320
MX
Trying to do the following in Excel 2000 VBA:
Sheet11.Range("J3").ClearContents
But J3, K3 and L3 are merged cells.

Thanks
 
Sort by date Sort by votes
Have you tried this ?
Sheet11.Range("J3:L3").ClearContents

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Here you are:
Code: 
Sheet11.Range("J3:L3").ClearContents

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
4K
dhookom
dhookom
remeng
  • Locked
  • Helpful tip
Microsoft Office 365 Word Macro Causing a Project is unviewable error
Replies
1
Views
1K
dhookom
dhookom
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
1K
hermanlaksko
hermanlaksko
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
1K
Katto
Katto
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
691
combo
combo

Part and Inventory Search

Sponsor

Back
Top