In each cell I have 1 small image over another big image. With VBA can I move the small image 5cm straight right, and then .05 cm up. Then lock the image together. Then perform the action in next row until there are images in rows of same column.
I don't understand everything you're asking, but here's an example of how to move each image on the worksheet to the right:
Code:
Sub moveImg()
Dim ws As Worksheet
Dim j As Integer
Dim num As Integer
Set ws = ActiveSheet
num = ws.Shapes.Count
For j = 1 To num
If ws.Shapes(j).Type = msoPicture Then
ws.Shapes(j).Left = ws.Shapes(j).Left + 2
End If
Next j
End Sub
what application are you working in? i sort of assumed word, bryce assumed excel
Then lock the image together
i assume you want to lock the image to the cell, but if the table moves or resizes, all the image may have to be moved to match
can you do this manually in the application? can you record a macro to do what you want?
post a sample document (or whatever type of data file), zip first, to give us a better idea of what you want to do
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case. Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
Reply With Quote
