Advertisement

09.02.2007 at 07:17PM PDT, ID: 22803003
[x]
Attachment Details

Excel VBA Object Variable or with Block Variable not Set

Asked by rpreiss in Microsoft Excel Spreadsheet Software, Visual Basic Programming

Tags: variable, excel, vba, set, block

I have this line of code and get the error message"Object Variable or with Block Variable not Set" what have I done incorrectly.

Set NewRng = Range(rgToUse, rgToUse.End(xlToRight)) 'Comment JR: added this line

Thanks.Start Free Trial
[+][-]09.02.2007 at 07:22PM PDT, ID: 19818764

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.02.2007 at 07:37PM PDT, ID: 19818800

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.02.2007 at 07:52PM PDT, ID: 19818835

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.02.2007 at 10:02PM PDT, ID: 19819158

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.02.2007 at 11:56PM PDT, ID: 19819421

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.03.2007 at 11:18AM PDT, ID: 19821663

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.03.2007 at 06:20PM PDT, ID: 19822763

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Visual Basic Programming
Tags: variable, excel, vba, set, block
Sign Up Now!
Solution Provided By: byundt
Participating Experts: 1
Solution Grade: A
 
 
[+][-]09.03.2007 at 07:15PM PDT, ID: 19822876

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.03.2007 at 08:38PM PDT, ID: 19823087

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628