i need a create a macro which goes down a table of results, say A1 to A10 and then selects that range then link it to this macro and paste the value into the bold area, the reason that it needs to be a loop is that the table of results will increase and these need to be displayed in a drop down menu any ideas? thanks
ActiveSheet.Shapes("Drop Down 39").Select
With Selection
.ListFillRange = " '$A$1:$A$10 "
.LinkedCell = "$m$14"
.DropDownLines = 8
.Display3DShading = False
End With
End Sub
ActiveSheet.Shapes("Drop Down 39").Select
With Selection
.ListFillRange = " '$A$1:$A$10 "
.LinkedCell = "$m$14"
.DropDownLines = 8
.Display3DShading = False
End With
End Sub