How can I take + export a screenshot of a range of cells as an IMAGE

C

curtoliver68

New Member
Joined
Nov 19, 2024
Messages
9
Office Version
  1. 365
Platform
  1. Windows
Is there a way to change the naming of the JPG from Capture.JPG to whatever text is in cell V3 and then .JPG?
 

Attachments

  • cellV3.png
    cellV3.png
    34.9 KB · Views: 5

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Sort by date Sort by votes
Welcome to the Board!

Sure, just change the:
VBA Code: 
& "Capture.jpg"
part to this:
VBA Code: 
& Range("V3").Value & ".jpg"
 
Upvote 0
Solution
You are welcome.
Glad I was able to help!
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question Question
Saving QR Image as JPG
2
Replies
12
Views
189
Bib195
B
pcc
  • Solved
Saving a picture
Replies
3
Views
273
Bib195
B
T
  • Solved
Extra Commas in Exported CSV
Replies
8
Views
220
tomgrandy
T
E
  • Question Question
Helps fix VBA code when inserting an image to another computer without causing the image to be blank
Replies
1
Views
196
DanteAmor
DanteAmor
E
  • Solved
How to insert jpg images into spreadsheet using VBA
2
Replies
12
Views
776
jolivanes
jolivanes

Forum statistics

Threads
1,225,155
Messages
6,183,215
Members
453,151
Latest member
Lizamaison

Share this page

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