Kb24
.End(xlUp) is normally used in conjunction with a command that looks upwards from the last row on a sheet to find the last used row in a particlar column - It is very useful if you do not know how many rows are populated
Example
As different versions of Excel have different total number of rows per sheet we use Rows.count to get the last row number - In most Excel versions this is row 65536
Assuming you do not have Excel 2007
The above code looks upwards from a65536
I just took a good look at your code, I only glanced at it last night
In your code you are testing the lenght & populating a c variable with a value but you do not give c a range address
As your loops are set to run 3 rows * 3 columns I suggestchanging the 2 loops to 1 loop
Bookmarks