-
loop through merged cells in a Column to get their addresses
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.
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
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
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
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
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...