this might be tricky and i dont know of this is possible but i guess it is
worth a shot to put up here.
scnerio:

i have 5 cells between category titles in column A. first title in cell a1
and second title in a7, so the 5 cells would be between a1, and a7. Each one
of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
returrns a value. not all these cells are filled, some are left blank. For
example there are 5 cells and 3 are filled because of the Vlookup, I want to
keep the three values, and have excel reformat the space inbetween cells a2
and a6 to three equally sized cells....

but then also do that same procedure column A:G

You cannot set row heights differently cells in the same row.

With Sheets("Sheet1")
.Rows("2:6").AutoFit
End With

--

Regards,
Nigel




"daphoenix" wrote in message
...
this might be tricky and i dont know of this is possible but i guess it is
worth a shot to put up here.
scnerio:

i have 5 cells between category titles in column A. first title in cell a1
and second title in a7, so the 5 cells would be between a1, and a7. Each
one
of those cells(a2:a6) uses a VLOOKUP function to another workshhet and
returrns a value. not all these cells are filled, some are left blank. For
example there are 5 cells and 3 are filled because of the Vlookup, I want
to
keep the three values, and have excel reformat the space inbetween cells
a2
and a6 to three equally sized cells....

but then also do that same procedure column A:G