Lazarus
asked on
VB Script Formula problem
Is there a way to change these so that if the Source Cell is empty that they either does nothing or places a vbNullString ? Currently it places a space when there is nothing there.
DestSheet.Range("I10") = SourceSheet.Cells(0 + Student, 1) & " " & SourceSheet.Cells(0 + Student, 2)
DestSheet.Range("J11") = SourceSheet.Cells(0 + Student, 2)
DestSheet.Range("I10") = SourceSheet.Cells(0 + Student, 1) & " " & SourceSheet.Cells(0 + Student, 2)
DestSheet.Range("J11") = SourceSheet.Cells(0 + Student, 2)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This solution works best for the script I'm working with, when using the If Len script is tends to skip certain fields in the worksheet and is also longer.
Cheers
Dave
Open in new window