+ Reply to Thread
Results 1 to 2 of 2

The simplest way to trim a picture pasted into excel

Hybrid View

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    The simplest way to trim a picture pasted into excel

    If I paste picture into a spreadsheet after pressing "print screen", what is the easiest way to crop it by X-amount of pixels from each of the 4 corners corners using VB? I tried recording this, but get a page-full of mambo-jumbo. Thanks.
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: The simplest way to trim a picture pasted into excel

    Try something like this...

    Sub Test()
    
    ActiveSheet.Shapes("Picture 1").Select
    
    With Selection
        .ShapeRange.ScaleWidth 0.6116072029, msoFalse, msoScaleFromTopLeft
        .ShapeRange.ScaleHeight 0.6116071429, msoFalse, msoScaleFromTopLeft
    End With
    
    End Sub


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to compress pasted picture
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2016, 09:48 PM
  2. Sizing and positioning a pasted range as a picture from excel to powerpoint?
    By dfowler31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2016, 07:16 AM
  3. Get alternative text of pasted picture
    By erstsck in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 03:21 AM
  4. Replies: 0
    Last Post: 02-10-2014, 12:29 PM
  5. changing property of a picture that is already pasted on excel
    By cc in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-10-2009, 09:33 PM
  6. Excel TRIM() can't handle   in pasted HTML
    By dyt in forum Excel General
    Replies: 2
    Last Post: 03-31-2005, 04:06 PM
  7. Replies: 2
    Last Post: 01-28-2005, 01:06 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1