PDA

View Full Version : [SOLVED] RANGE OF CELLS TO IMAGES



branston
10-02-2019, 07:27 AM
Hi

I am trying to copy a range of cells (names only) and save/paste those ranges as 4 seperate pictures ideally within the same worksheet (or another tab if easier).

At the moment I can only export Set 1 as a picture and the range is "fixed". The range being fixed is a problem as the range of each list can change length. Ideally I would like one macro rather than 4 do this task.

I've attached my sheet and would appreciate somebody taking a look. Not sure I am tackling this the right way and/or maybe there is a better way to do it.

TIA

branston
10-02-2019, 09:54 AM
This sort of does it for those that might want to know. Thanks to dave.



Range("A2:D13").CopyPicture
Range("S3").PasteSpecial