[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Simple Troubleshooting for Spreadsheet

Posted on 2011-09-23
3
Medium Priority
?
256 Views
Last Modified: 2012-05-12
EE Professionals,

I have a neat application / workbook that EE helped build.  I have a slight bug that I cannot find.  It has to do with the auto sort in Column A and specifically A4.  If you put in a higher number in A4, it does not autosort.  If you change the number in A5 or beyond, it does.

I think this is a very simple fix.  Please let me know; I'm trying to learn.

Thank you,

B.
RASCI-Sheetv71.xlsm
0
Comment
Question by:Bright01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
Arno Koster earned 2000 total points
ID: 36586534
The problem is this line :

.Header = xlYes

Open in new window


this indicates that the top cell (A4 in this case) contains a header which should not be sorted.

You either have to change all ranges to A3:A... or set .Header = xlNo
0
 

Author Closing Comment

by:Bright01
ID: 36586842
Fast, knowledgable and meaningful fix.  Thanks for the fix and the lesson!

B.
0
 
LVL 19

Expert Comment

by:Arno Koster
ID: 36587137
You're welcome !
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

650 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