How to calculate the number of the cells and their RANGE for Predfined AREA in EXCEL (BY WIDTH AND HEIGHT IN PIXELS)

archanasinghvi

New Member
Joined
Dec 15, 2011
Messages
6
Hi,
i will explain you the things one more clear way.
lets have the snapshot.
45040


so as per the image , the user will select the GRID SIZE, then template and according to this it will select the WIDTH and HEIGHT in PIXELS.
so the CELL WIDTH AND HEIGHT WILL BE ADJUSTED EQUAL TO GRID SIZE IN PIXELS.
and then it will CALCULATE THE TOTAL NO OF CELLS FOR THE SELECTED WIDTH AND HEIGHT IN PIXELS.
SO THAT IT CAN PAINT THOESE CELLS ONLY IN WHITE COLOR FOR STARTING DESIGNING.
LETS SUPPOSE IT WILL SELECT THE CELLS STRATING FROM A1 to equal to that width and height in pixels.
YOU CAN UNDERSTAND IT AS in non technical term YOU have a big RECTANGLE and you have to draw a small rectangle in it for particular width and height.
please see how it will happen
45049


Are you able to see the above screen , the result will come in this form. The particular cells are counted on the BASIS OF grid SIZE, WIDTH AND HEIGHT in pixels are painted WHITE . REST CELLS ARE SAME.
MAY BE i am not that much technical expert in telling you the techy things but this is my requirement.
Please help me so that i can proceed ahaed.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,216,733
Messages
6,132,413
Members
449,727
Latest member
Aby2024

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