Go to end row

Excel Help for Go To End Row in Automating Data Analysis Tasks

Find Excel Solutions


Search Forums:
Recent Activity:
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac
Portfolio Performance Monitoring And Valuation
Importing Data From Pdf Files
Help Required From Administrator
Can't Get It To Give Me The Report I Want




Follow Business Spreadsheets On:
 
Forum TopicLogin

Go To End Row

Rate this:
(3/5 from 1 vote)
OopsYou probably need to find the last cell in the column and then offset 1 down to populate the the row with the new date and price.  We can do this in VBA like:
VBA Code:
Selection.End(xlDown).Offset(1,0).Select

There is an open source program to download market data for multiple stocks that we developed here. This has a lot of code that might also help with your project.
 Excel Business Forums Administrator
 Posted by on
 
View the "Using excel to automatically build a database of stock data" Topic

Excel templates and solutions matched for Go to end row:
Solutions: Budget Planning

 

Find Excel templates
and add-ins in the
Excel Business Solutions Directory
   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |