If I copy some cells (simply containing numbers) from filtered column, how can I further reference this data from VBA?
If I try this:
Dim DataObj As MsForms.DataObject
Set DataObj = New MsForms.DataObject
DataObj.GetFromClipboard
Debug.Print DataObj.GetText(1)
I get this error:
DataObject:GetText Invalid FORMATETC structure
Is there any other way to access the data from copied filtered cells?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…