Login|Contact Us
Question and Answer

Programming

Ask a Programming Question, Get an Answer ASAP!

  • Ask A Question
  • Browse Answers
  • Meet The Experts
  • How JustAnswer Works

I need help with VBA for Excel 2007

 
J. Mar's Avatar
  • Answered by:J. Mar
  • Consultant
  • Positive Feedback: 100.0 %
  • Accepted Answers: 120
Verified Expert
in Programming

Recent Feedback

Positive
Great job, thank you!
Positive
Could not be any more satisfied. He took on a problem that others said couldn't...
Positive
Absolutely wonderful, exactly what I needed and within a time frame that amazes...
Positive
Thanks John - that's exactly what I meant! Have good day.
Positive
Very impressed, thanks for your help. Saved me a lot of time.
Positive
I thought the resolution to my problem was not possible. I am extremely...
Positive
Thanks again! You are my hero!!
Positive
Awesome!!! Very timely reponse and it's worked perfect! Thank You!
Positive
Quick response and got the right answer the first time.
Positive
Just and outstanding "Expert" with in-depth knowledge of Excel Programming and...

Customer Question

I need help with VBA for Excel 2007 syntax help .Range("B7").Formula = "=IF(ISERROR($J$4),""""), IF($J$4>=1,$C$5,""""))" This is not correct, can you correct it for me?

 

Optional Information:
Computer OS: Windows 7
Browser: IE
Programming Language: VBA

Already Tried:
I need help with VBA for Excel 2007 syntax help .Range("B7").Formula = "=IF(ISERROR($J$4),""""), IF($J$4>=1,$C$5,""""))" This is not correct, can you correct it for me?

Submitted: 645 days and 23 hours ago.
Category: Programming
Value: $22
Status: CLOSED
Picture
Expert:  J. Mar replied 645 days and 21 hours ago.

Thank you for asking your question on JustAnswer. My name is XXXXX XXXXX X will be happy to help you.

 

 

Looks like you had an extra ")" in the formula

 

.Range("B7").Formula = "=IF(ISERROR($J$4),"""", IF($J$4>=1,$C$5,""""))"

J. Mar40757.4151343403

 
Tweet

3 Programmers are Online Right Now

Ask Your Question Now
Programming Questions Date Submitted
I need to make a inventory program for CS 115. I've had a very 5/2/2013
I want to get into programming but have no prior experience. 5/2/2013
Street Light Verilog Code 5/1/2013
Based on your new found knowledge and experience in problem 4/30/2013
this is a GUI done in C# Create an application in which a 4/29/2013
I am trying to use vba to click a button on a webpage but can't 4/29/2013
For LogicPro only:Help with Java Programming project. 4/29/2013
Drink Machine SimulatorWrite a program that simulates a 4/28/2013
Implement a class Car with the following properties. A car 4/27/2013
***The Doctor***I purchased a web template and I am currently 4/27/2013
RSS
Next 10 >
Ask A Programmer
Type Your Programming Question Here...
characters left:

Top Programming Experts

See More Programmers

In The News

Nbc
Washington Post
New York Times
Cnn
Learn More

How It Works

  • Ask an Expert
  • Get a Professional Answer
  • Ask Followup Questions
  • 100% Satisfaction Guarantee
Learn More
close
Find Expert answers related to your question.
Sign up using email
We will never post anything without your permission.
Already have an account? Sign in

Ask a Programmer

Get a Professional Answer. 100% Satisfaction Guaranteed.
88 Programmers are Online Now
Type Your Programming Question Here...
characters left:
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.
Truste
Contact Us | Terms of Service | Privacy & Security | About Us | Our Network
© 2003-2013 JustAnswer LLC
  • Pearl.com
  • JustAnswer UK
  • JustAnswer Germany
  • JustAnswer Spanish
  • JustAnswer Japan