Learn Excel - Select Every Other Cell - Podcast 2108

Kuldeep wants to select every third cell for 1500 cells The macro code to union all 500 cells is too long and causes a compile error! Solution: Build 1, blank, blank. Copy those three cells and paste to 1500 cells Select the 1500 cells. Home, Find & Select, Go To Special, Constants to select every third cell Then, one line of VBA to move the selection N rows or columns away. Finally, a VBA Macro to do the whole thing Cool Tip: If you use Ctrl+G for Go To dialog, it shows recently selected ranges. Cool Tip: In the Go To dialog, hold down Shift to select from Current Cell to the Go To cell. VBA Tip: Using UsedRegion to find the last row in the worksheet

Microsoft Excel,Excel,Bill Jelen,MrExcel,How to select every other cell in Excel,How to select every third cell in Excel,