Hi Team,
'Help1 - Need help in declaring variable for Application.worksheetfunction.
Dim wsf As object or Variant
Set wsf = Application.WorksheetFunction
With wsf
wsf. 'not getting help after pressing wsf.
end with
Help2 - Can we shorten the code below in a single line
Range("c3:c8").value ="-"
Range("e3:e8").value ="-"
Range("g3:g8").value ="-"
Range("I3:I8").value ="-"
Range("K3:K8").value ="-"
Range("M3:M8").value ="-"
Range("N3:N8").value ="-"and so on till Till Range("v3:v8")
Thanks for your help in advance!
Regards
mg