Results 1 to 3 of 3

Add-in to set column width and row height based on pixels in cell

Threaded View

  1. 02-26-2016, 04:01 PM #1
    CobraLAD
    CobraLAD is offline
    Forum Contributor CobraLAD's Avatar
    Join Date
    07-23-2007
    Location
    Boksburg, South Africa
    MS-Off Ver
    Office 2019
    Posts
    346

    Add-in to set column width and row height based on pixels in cell

    Hi everybody

    I created a simple formula to work out the character column width from the pixel value for example 64 pixel = 8.43 character. I also built an add-in to adjust the width and height by using the pixel value. I would like to share this.
    Must I put the formula in the Excel Formulas & Functions section and the add-in in the Excel Programming / VBA / Macros section, or can I put it in one post somewhere.

    Screenshot of add-in.
    Name: column & row pixel adjuster.png Views: 5033 Size: 36.6 KB
    Last edited by 6StringJazzer; 02-27-2016 at 03:24 PM.
    Regards
    LAD
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Locking Column Width and Row Height
    By Zaraf in forum Excel General
    Replies: 7
    Last Post: 12-02-2013, 10:08 AM
  2. Need height and width of plot area to equal height and width of chart area
    By WBJohnston in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-22-2013, 12:19 AM
  3. Setting column width and row height
    By meherts in forum Excel General
    Replies: 1
    Last Post: 07-16-2010, 11:05 AM
  4. [SOLVED] auto fit column width and row height
    By kb in forum Excel General
    Replies: 0
    Last Post: 05-22-2006, 03:00 PM
  5. [SOLVED] Row height/column width
    By Connie Martin in forum Excel General
    Replies: 1
    Last Post: 03-20-2006, 12:55 PM
  6. Column Width and Row Height
    By Pillow in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-13-2005, 12:00 PM
  7. [SOLVED] Row height & column width numbers..?
    By Frank in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-04-2005, 01:05 PM
  8. Displaying column width and row height
    By swirlygirl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1