Aug 1, 2011 · Hi, Im new to VBA and have come into a few instances where I have tried, unsuccessfully, to create a macro that will select every other row and then copy that selection. …

Feb 15, 2002 · Hi everyone Im trying to find a way select several rows at the same time but starting at say row 3 and then alternate rows so rows 3,5,7,9 etc Can anyone advise please …

Nov 16, 2018 · Hi, I have a row of numbers with more than 100 cells. I need to "Select" every other cell to use in a formula. Example: SUM(A1+A3+A5+A7 ... GA1+GA3) How can I …

Apr 14, 2017 · Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of …

Dec 4, 2006 · I am wondering how to make alternate rows different heights throughout an excel sheet. I know how to go and select every other row and then change the row height, but this is …

Aug 21, 2003 · For the other approach you dont need to add a column. What Gastrifitis was refering to was the conditional formating under the format menu. Just highlight your entire …

Apr 5, 2013 · Hi everyone Im trying to find a way select several rows at the same time but starting at say row 3 and then alternate rows so rows 3,5,7,9 etc Can anyone advise please regards …

Sep 4, 2008 · A simple way to get a blank row in-between each row is to insert a new column at the begining of your spreadsheet (Column A). Use a fill series of numbers in the new column …

Sep 24, 2008 · Thanks for all the great replies. For some reason, nothing works for simply trying to 'select every other row'. If it helps, there is data in all rows (no blanks) and I merely wish to …

Aug 4, 2008 · This code will select every other column (entire columns) in the range of columns within the current selection. Figuring out how to do this with other frequencies is an exercise …