Selecting Data for Graph

[jnoble01]

Hello,

I am trying to select data for a graph and am having some trouble. The data is super long and not practical to select and scroll all the way down to get all the data so i wanted to just select the entire column from a starting point. I need to be able to change the starting point so i was wondering if there was a way to do this by using the inputbox feature. If not what is a good way to go at it?

Thank you!!

[simarui]

select the first cell and holding ctrl + shift press down (or right / left / up). This select all the way to the last cell with data in that direction.

if your data has spaces, ctrl + shift press end will go to the bottom row and furthest right column with data...

[jnoble01]

thank you, but do you know if there is a way to write that into a code in visual basic. like have an input box that asks for a cell to start at then it automatically selects every cell below it?

[Steve=True]

Hi jnoble01,

Welcome to the forum!

Continuing with simaraui's post, you can use the F5 key to get to where you want and then use the CTRL+SHIFT technique.

Here is a step-by-step tutorial and video tutorial:
How-to Quickly Select a MASSIVE range in an Excel Spreadsheet

Let me know if it helps.

Steve=True

[simarui]

i'm sure there is...

little pressed for time, are you familiar with VB?

Please Login or Register  to view this content.

does what i just described. as for the input box i believe you just need to insert a userform with a listbox and then add a .Select command to the range defined in that list box... sounds a little more complicated than the method i just described to me though...

[jnoble01]

I'm kinda new to VB. that works thanks. I know the other way is easier I am just trying to make some what of a template for others so they can use this once data is changed or moved around.