+ Reply to Thread
Results 1 to 2 of 2

Descending Picture

  1. #1
    Registered User
    Join Date
    11-07-2006
    Posts
    1

    Question Descending Picture

    Evening All,
    I have a spreadsheet that requires more rows each day. At the end of the last entry in column A I want to insert a picture (say from clipart), each time another entry is made (another row) I want the picture to descend to the cell beneath the last row entry. Is this possible to do using VBA, if so please try to explain clearly (I'm only a novice).
    Many Thanks Ian

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    The best way to learn is this.

    Turn on the Macro Recorder Tools\Macro\Record New Macro

    Select a cell in your sheet.
    insert some clip art

    Select a different cell in your sheet
    Insert some different clipart

    Stop the macro recorder.

    Press Alt F11 to open the macro editor and have a look at the code that was generated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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