Jagwarman
asked on
Ignore statement
I am using the following piece of code which works fine when there is data to collect
strRange = Left(strRange, Len(strRange) - 1)
.Range(strRange).Copy
But it falls over with the statement 'Invalid procedure call or argument' when there is no data.
Could an expert out there provide me with the code that will move the code past this so that it does not fall over when there is no data
Thanks
strRange = Left(strRange, Len(strRange) - 1)
.Range(strRange).Copy
But it falls over with the statement 'Invalid procedure call or argument' when there is no data.
Could an expert out there provide me with the code that will move the code past this so that it does not fall over when there is no data
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
d'oh, thanks for the catch