pixels

  1. R

    Calculation based on existing column, don't know range

    Need help with the following: I have a height and width column in pixel count. I convert the pixels to inches without a problem. How do I figure out the last row in the column. They amount of rows will change every time I pull my data. In other words, how can I create my calculation for each...
  2. M

    Simple way to increment by 10% until a value is reached?

    Hi all, I am working on resizing an image in Photoshop rather drastically, and one of the tips to to go in 10% increments until I reach my goal, and since I am looking at roughly 100 steps, I was thinking that I could calculate my numbers in Excel. I'm just not sure how to do that. I am starting...
  3. F

    Windows DPI Settings Affecting P_rint

    Hello, I am trying to create a series of forms to be used throughout my company but have noticed they print different on other user's computer's than my own. I used VBA to manually set the print margins and print area, but the problem persisted. After much frustration, I came to realize that...
  4. J

    Cell Size ratio ??

    This is just to satisfy my own curiosity Why is Cell height measured differently than Cell width? Standard Cell height is 15, which is equal to 20 pixels, and that's about 1/4 inch. And standard Cell width is is 8.43 which is equal to 64 pixels and that's about 3/4 inch. So my first question...
  5. S

    Counting the number of white pixels in a Bitmap image

    Hi, I’m wondering if it’s possible – using VBA in Excel 2013 on Windows 7 – to open a bitmap image and count the number of white pixels contained in it? Searching the forum I found this old thread which appears to be asking a similar question. There was a promising reply but the OP didn’t...
  6. S

    Row height - point size and pixels

    Hello, I'm having a strange problem. I have Excel 2007 installed on multiple machines in an office. On nearly every computer, a row height of 1 pixel corresponds to 0.75 points. However, on one system (a Dell laptop), a row height of 1 pixel is corresponding to 0.6 points. This ends up...
  7. S

    Text width in pixels

    Hello, I need to get width of text in pixels. I need it for two reasons: 1) to be able to use Data Validation and UDF in a way that user won’t be able to type text which does not fit in the cell 2) to be able to do the same as in (1) but with ~ 50 000 string queries at a time (I will read data...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top