Hi there,
I have a problem that i need to solve fast, time is very short...
The problem is:
i have an input worksheet, with several rows formated as text, with row height set to autofit.
This text rows, i need to import in a collector worksheet, which gets data from lots of worksheets. The problem is that in the collector worksheet, i cannot set row height to autofit, and i have to find a way to extract the row height from the text input worksheet and use this height to format the collector worksheet rows...
The challenge is that i change frequently the text source( the collector is always the same) and i cannot edit links in VBA.
I am sure there is a simple solution to this, like a user defined function, and i need a start point...
Thanks in advance