Go to end row

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

Find Excel Solutions


Search Forums:
Recent Activity:
Can't Get It To Give Me The Report I Want
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?




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 |