Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Carlo,
thank you for your reply, but like I said, I already read the vba help summary and I really don't understand the terms used like "floating point", etc. etc. I was hoping for someone could explain in lay terms the difference between the different data types that allow decimals. p.s. in case anyone is pays attention to my picture resizing sub where you only know the width, I caught a boo boo and here's the revised sub: SUMFB.Activate SUMFB.Cells(15, 16).Select '''VARIABLE PRM Set pSketch = SUMFB.Pictures.Insert("C:\Documents and Settings\Olab\My Documents\0- Wear Testing\Sketches\" & sStyle & ".jpg") '''VARIABLE PRM With pSketch PicHt = .Height PicWd = .Width .Select .Width = 240 PicRatio = .Width / PicWd .Height = PicHt * PicRatio .Top = .Top - .Height + 1 End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert, position, and resize a picture w/ Macro | Excel Discussion (Misc queries) | |||
Resize Last Row to Fill a Page Width | Excel Discussion (Misc queries) | |||
resize row height and column height | Setting up and Configuration of Excel | |||
resize row and colomn height | Excel Programming | |||
get a picture width and height without inserting the picture | Excel Programming |