Just a guess but swap the "," and "iLastRow3" in the Resize function,
the normal syntax is Row, Column. Therefore the Columns resize worked
fine but the Rows needs changed
Die_Another_Day
leonidas wrote:
Hi,
The same problem but then with rows. I have tried the code below, but
it doesn't work.
How should I change the code to get it to work. Thanks in advance!
Code:
--------------------
iLastRow3 = Cells(Rows.Count, "B").End(xlUp).Row
Rows("10:10").Resize(, iLastRow3).RowHeight = 15.75
--------------------
--
leonidas
------------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=566638