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

Go to end row

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


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 Full Post

Excel templates and solutions matched for Go to end row:

Solutions: Budget Planning