Setting row & column sizes

  • Thread starter Thread starter Quincy
  • Start date Start date
Q

Quincy

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!!
 
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
 
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
 
Back
Top