View Single Post
 
Old 07-25-2014, 03:36 AM
Cerian Knight's Avatar
Cerian Knight Cerian Knight is offline
Polymath (in disciplina)

Super Moderator
* Expert *
 
Join Date: May 2004
Location: Michigan
Posts: 4,191
Arrow

I believe you should rewrite to specify Imports to use with Range, etc. That might also fix the Intellisense, but not sure. See here for an example:
http://support.microsoft.com/kb/302094
You also should not have to Dim the xl constant values (xlSortOnValues, etc.) yourself, as they should come with the Imports.

To answer the second question, use With...End With if necessary, but notice how the example avoids that issue.

Do that and then let us see what you have if the Sort is still not working (after Dim using r1 as an Excel.Range).
__________________
I got all the answers wrong on the GLAT, apparently even #9 (where I put a period in the middle of the box and labeled it 'singularity ripe for rapid inflation').

Last edited by Cerian Knight; 07-25-2014 at 04:17 AM.
Reply With Quote