ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   error! (https://www.excelbanter.com/excel-programming/311534-error.html)

porkie[_7_]

error!
 

opps! i found the error!

it should have been For Each cellColour In Range("B5:BA100").. and no
For Each cell In Range("B5:BA100"

--
porki
-----------------------------------------------------------------------
porkie's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26371



All times are GMT +1. The time now is 12:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com