Say in Range("A1:A25") (named range or not) I want to loop through that range but only enforce code on cells that have been selected prior to running my loop.
Something like
Dim c as range
Dim cV as string
For each c in Range("A1:A25")
with c.selection
cV = c.value
do something with cV
end with
Next
The range is a list of names of worksheets.
If that name is selected then cV.Delete
Thanks,
Howard
Something like
Dim c as range
Dim cV as string
For each c in Range("A1:A25")
with c.selection
cV = c.value
do something with cV
end with
Next
The range is a list of names of worksheets.
If that name is selected then cV.Delete
Thanks,
Howard