Setting row & column sizes
 

Hi,
Is there any way to set row heights and column widths by entering the
sizes needed (in pixels) in the first cell of those rows and columns?
Example:
B1 = 14
E1 = 27
G1 = 14

A2 = 21
A7 = 16
I have to paste multiple(!) bitmap objects into cells for printing ith
labels sized below each object. It is extremely tedious and time
consuming to resize all of the different cell sizes needed.
My programming skills consists of being able to find this newsgroup.
Any help would be GREATLY appreciated!!

Setting row & column sizes
 

Check out this thread on the same topic:

Getting Column width using macro... by KM on Nov 7 2003 12:47PM

I always search the newsgroup before asking since the topic
is probably in there somewhere.....

Good Luck!!

Steve

Setting row & column sizes
 

Pictures aren't pasted into cells, they are pasted above cells, so there is
no reason to change the cell sizes unless you want to use them as guides.

Also, excel doesn't support sizing cells to specific pixel measurements for
width. Column width has to do with the width of the characters of the
default font. RowHeight is set in points. So if you can translate your
pixels to points, you could set the row height.

ActiveWindow.PointstoScreenPixelsX
ActiveWindow.PointstoScreenPixelsY



--
Regards,
Tom Ogilvy


"Quincy" wrote in message
m...
Hi,
Is there any way to set row heights and column widths by entering the
sizes needed (in pixels) in the first cell of those rows and columns?
Example:
B1 = 14
E1 = 27
G1 = 14

A2 = 21
A7 = 16
I have to paste multiple(!) bitmap objects into cells for printing ith
labels sized below each object. It is extremely tedious and time
consuming to resize all of the different cell sizes needed.
My programming skills consists of being able to find this newsgroup.
Any help would be GREATLY appreciated!!