Hi all, Ive created a VB code that inputs data from the user then creates a graph from the numbers entered. the problem im having is that when the code shifts the columns by 1 to the right it also moves the data range for the graph in this direction too, is there a function that can select all the data within a row similar to the shortcut of ctrl+shift+dire ction in excel?