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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks