offset function in ecel 2010

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
offset function in ecel 2010

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 25th, 2015, 02:00 PM

jtrifts

Authorized User

Join Date: Aug 2004

Posts: 24

Thanks: 0

Thanked 0 Times in 0 Posts

offset function in ecel 2010

I am creating a dynamic chart in excel 2010. I am using the offset function that will cover a range of cells. The problem is that the range has some if functions that may return nothing. ie =IF(4>5,11,"") The offset is still picking up the field. So is nothing eg "" something. Any idea how to get around the problem.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pop-ups and arguments descriptions in VBA Function (Excel 2010)	sektor	Excel VBA	2	May 28th, 2010 04:52 AM
WorksheetFunction.Match function problem [Excel 2010]	sektor	Excel VBA	1	March 10th, 2010 06:22 PM
Visual Studio 2010 in Focus at Great Indian Developer Summit 2010	shaguf5575	ASP.NET 1.x and 2.0 Application Design	0	February 24th, 2010 07:03 AM
Visual Studio 2010 in Focus at Great Indian Developer Summit 2010	shaguf5575	ASP.NET 1.x and 2.0 Application Design	0	February 24th, 2010 07:02 AM
ecel 2007 macro	nankeen	Excel VBA	0	December 2nd, 2007 11:40 PM