This macro takes a screenshot of the selected cell range and saves the image to c:\temp\temp.gif.
Print screen and save the picture to a folder automatically Printer Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture Picture Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture What VBA code does the macro recorder create while taking a screenshot of a cell range?īitmap Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap The image above shows a screenshot with settings "As shown when printed" resized to fit this webpage. Paste the picture in your favorite image editing software which allows you to rescale the image to a smaller size.Press with left mouse button on OK button.Select radio button "As shown when printed". Press with left mouse button on "Copy as Picture.".Press with left mouse button on the arrow near the copy button, see image below.Enable check boxes for Print "Grid lines" and Print "Headings".It is possible to include headings but you need to select "As shown when printed" and then resize the picture in your image editing software. Format - Picture and Bitmap is greyed out. The image above shows the dialog box when the radio button "As shown when printed" is selected.
The "As shown when printed" setting returns a really large image and I am not going to show the full-size image here to you, for obvious reasons. The "Bitmap" setting returns a much nicer looking image: The "Picture" setting returns a terrible image, shown here: If you select the radio button named "As shown on screen" you can choose from "Picture" or a "Bitmap". I will explain these settings in greater detail below. A dialog box appears, here you can select if you want it "As shown on screen" or "As shown when printed".Press with left mouse button on "Copy as picture.". Press with left mouse button on the black arrow near the copy button, see image below.Select the cell range you want to capture a screenshot of.Press shortcut keys CTRL + A, this selects the entire data set as long as data cells have no blank rows in between. Press with left mouse button on and select any cell in the data set. The image above shows a part of a data set containing random data, here is how to quickly select a larger data set without scrolling. Print screen and save the picture to a folder automatically (vba macro)Ĭheck out the macro category for more useful VBA subroutines.How to take a screenshot of a large area in Excel.
0 kommentar(er)
