lesson

This Week's Hot Topics

• loop through merged cells in a Column to get their addresses

  • Replies: 46
  • Nov 27, 2019

  I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas...
• Split a Column into 2, use a character limit that does not cut words in half.

  • Replies: 31
  • Nov 26, 2019

  Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The...
• change colour of picture based on cell value

  • Replies: 44
  • Monday at 8:25 AM

  hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am...
• Preventing duplicates

  • Replies: 24
  • Nov 26, 2019

  Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for...
• EXCEL SHEET auto enter Dates

  • Replies: 23
  • Nov 25, 2019

  Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help...
• Code giving run-time error when called, but not when placed on worksheet.

  • Replies: 23
  • Monday at 7:16 AM

  The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...