Solved

VS 2005 End Error

Posted on 2007-11-14
6
135 Views
Last Modified: 2013-11-26
Hi

I am getting an error on the code that I am converting from VBA to Visual Studio
= xlRange.Range("A" & RowNum).End(xlToRight).Column
The error is occurring on the xlToRight
0
Comment
Question by:murbro
  • 4
6 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20278379
Hi murbro,

Use this....

    xlRange.Range("A" & RowNum).End(Excel.XlDirection.xlToRight).Column

...or you can create your own constants....

    Public Const xlToRight As Integer = Excel.XlDirection.xlToRight

...and use your original VBA code.

Regards,

Wayne
0
 
LVL 23

Accepted Solution

by:
Ashish Patel earned 500 total points
ID: 20278383
It should be like this
= xlRange.Range("A" & RowNum).End(Excel.XlDirection.xlToRight).Column
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20278429
Can you please explain how the selected response differs from the one I suggested 2 minutes beforehand?
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20278439
0
 

Author Comment

by:murbro
ID: 20278574
Hi

Sorry error on my part. Scrolled down too quickly. Can I reallocate the points
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 20278601
Yes, you can ask a question in Community Support and ask for the question to be reopened.

http://www.experts-exchange.com/Community_Support/General/
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now