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