-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copy format
-
E
Adding multiple colors to text in multiple cells
Hello, I'm looking for some help on adding text color to a column of text but with a unique twist to it. Below is a screen shot of the data i'm working with. The first row is how I want all the rows to look like when complete. I used the formula Concatenate to combine the columns together but...- ETNA91
- Thread
- copy format formula text color
- Replies: 3
- Forum: Excel Questions
-
D
An alternate for PasteSpecial Paste:=xlPasteFormats
Hi, The goal of my macro is - For a particular condition of a column, (Field 'Detailed Status' when having a value 'Escalated') copy certain columns to a new Excel worksheet. Points where I need help is 1. I have been using PasteSpecial Paste:=xlPasteFormats while copying as shown below. But...- Dhanya Saseendran
- Thread
- active folder copy file copy format
- Replies: 0
- Forum: Excel Questions
-
W
Active X button, VBA to copy format and formula of above cells.
I'm trying to make the button find the last instance of a non-empty cell in column B, then select the row between (B:L) from the last non-empty cell in column B. Copy the format and formula in the selection then insert a new row below and insert the format and formula. The reason I'm not using...- Winklevos
- Thread
- copy format copy formula excel excel & vba
- Replies: 0
- Forum: Excel Questions
