Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub InsereFotografia() On Error Resume Next Dim result() As String result = Split(ActiveCell.Value, "-") Dim num As Long num = result(0) ActiveCell.Offset(-2, 0).Select ActiveSheet.Pictures.Insert( _ "P:\Backup Montagem Final\ARQUIVO\Agenda MF 2011\FOTOS MF 2011\000" & num & ".JPG").Select End Sub
|why excel offset of negative and positive shows incorrect Delta, please see attached||2||17|
|Excel VBA - triggering a Sheet event on another workbook||3||29|