$$Excel-Macros$$ need code to check unreplied email in the outlook

2016-04-12 Thread Sunil Patil
Hi , Please update if anyone knows about this -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Johnny
Paul, thanks for taking a look. I start by copying the contents of the MASTER SAVE tab and paste values into Cell A1 of Worksheet tab. I then run the macro NCFL_cleanup to get rid of everything on that page except the single column of data I want to use. The idea is then to paste the column of

Re: $$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Paul Schreiner
Can you attach an example?It's difficult to guess what MIGHT be happening based on your description. When you "copy" the data into the cells, are you pasting the entire contents or have you tried to "Paste Special -> Values"? Are the values numeric or alpha-numeric? It's possible when you copy

$$Excel-Macros$$ Copying data into a cell with Conditional Formatting already applied

2016-04-12 Thread Johnny
Hi All, I searched for an answer on this first but I'm hoping for some easy, good advice. Using VBA, I have preloaded some cells with formula-based conditional formatting. When I copy a column of data into these cells, the conditional formatting does not take effect. Also, formulas in