This method will always return the last row/column whether it's hidden or not.
Or, to find the last column: Rows("1:1").Find("*",SearchDirection:=xlPrevious).Column Find like this: Range("A:A").Find("*",SearchDirection:=xlPrevious).Row When I need to find the last row in my dataset, I use. End(xlDown) (or variants) because it can be unreliable when rows are hidden or when the column/row has noncontiguous data. When I need to return the last row or column that contains data, I usually avoid using. To my knowledge there shouldn't be any difference between a MAC and PC in this regard.
Atlasti merging data between pc and mac for mac#
I'm using Excel for Mac 2011 (OS X Mavericks), and Excel 2010 (64-bit Windows 7 - both via Boot Camp and Parallels 9) However, on a PC I get an answer that is 1 too many, so I have to alter the line to look like this: Cntr = Range(ActiveSheet.Range("A17"), ActiveSheet.Range("A17").End(xlDown)).Countĭoes Range.Count work differently depending if you are using a Mac or PC? I suppose I could loop through the data and get a count that way but that seems wasteful.
On the Mac, this gives the correct number of data points. The code I use for the number of data points is: Dim Cntr As LongĬntr = Range(ActiveSheet.Range("A17"), ActiveSheet.Range("A17").End(xlDown)).Count I would like the sheet to work on either a Mac or a PC, and therein lies the problem. The data itself gets downloaded such that Row 16 is a header row and everything beginning on Row 17 is data.
I am downloading historical stock price data from Yahoo Finance I need a count of the number of data points that get downloaded.
0 kommentar(er)
