pixels

1. 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. 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. 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. 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. 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. 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. 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...

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.

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

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