Category Archives: Excel

Strategies for getting the last row in Excel with VBA

Using VBA to get the last row in Excel can be a surprisingly complex task. This post will explore some of the different strategies you can use. The first thing to do is to decide what you mean by “The … Continue reading

Posted in Excel, Formatting, VBA | Tagged , | 7 Comments

Excel JavaScript API Part 5: The large numbers bug

There is currently (JavaScript Excel API set 1.4) a rather nasty bug when writing large integer numbers (anything larger than int32) back to a range. The JS can correctly read these large numbers – it just silently gets the wrong … Continue reading

Posted in Excel, JS-API | Tagged , | Leave a comment

Excel JavaScript API Part 4: The shallow copy problem

I was trying to read the values from a Range and then write modified versions of the values to two different ranges. Should be straightforward: Well this does not work: both B4 and B6 have 0.91 added to them: wrong … Continue reading

Posted in arrays, Excel, JS-API | Tagged , | 1 Comment