Most valuable professional
  • Hot Topics

Excel Copy cell above if it has no colour fill. Macro.

Hi, So I have a small problem. I have a bunch of data which covers over 13000 rows and 64 columns. This extract lists changes in information but it only highlights the changes anything that hasn't changed is left blank. The information is always listed as 1 line with all old information followed by the line below with no information except the new information. New information can be that the change is to blank. new information is highlighted in Yellow. Therefore using F5 - Special - Blanks doesn't work. e I need a quick vb code which simply fills in info from the line above IF that cell does not have any colour in it. (R:-1C) I hope that I have been clear. Thanks in advance. Kirnon.

This question generated 40 answers. To proceed to the answers, click here.

This thread is current as of August 27, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel