Go to end row

Excel Help for Go to end row in Automating Data Analysis Tasks

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Automating Data Analysis Tasks > Using excel to automatically build a database of stock data > Go to end row

Forum Topic

Go to end row

Rate this:

(3/5 from 1 vote)

You 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 Excel Helper on 23-Feb-2012

[View the Full Thread for the "Using excel to automatically build a database of stock data" Topic]

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

Find Excel templates
and add-ins in the
Excel Business Solutions Directory