Selecting range in VB

  • Thread starter Thread starter Frustrated_User_in_West_Virginia
  • Start date Start date
F

Frustrated_User_in_West_Virginia

I wrote a Macro to sort a range. The rows in the range
change from day to day. I can define the "boundrys" of the
range by two variables x and z.
I am declaring these as variant
I define x = Cells(I,3)and z = Cells(J,26)
I and J vary depending on the data source.
I can run this Macro when I have the data on one
spreadsheet, and it does what I wwant it to do.

When I insert this Macro on a Mega VB Macro I get an error
Message" Object Variable or With Block Variable not set"

I have consulted with several VB users in my company. They
can not find the error.

Avyone out ther knows what is the problem?
 
Hi Frustrated User,

This is a VB.net language group.

It seems for you the right place, we do seldom something with Excel and than
seldom again in the way you uses it.

And as I understand it goes deep in Excel.

Probably you will get a good answer in one of the Excel newsgroups.

Sorry I cannot help you,

Cor
 
Back
Top