I've been using this website almost religiously to learn the ins and outs of VB...
The issue i have is a two parter: (1st part is what i need help with)
Simply trying to create a loop that will select range "H5:H201" and
make it equal the value of another range (EG5:EG201) (actually on another sheet, even though i haven't id'd the sheet)
Picking only the odd numbers in the range
This would be a lot quicker and easier than typing in each range i want to activate.
Sub ActivateRange() Application.ScreenUpdating = False Dim x As Integer Dim board As Range Dim from As Range For x = 5 To x = 201 board = "H" & "x" from = "EG" & "x" ActiveWindow.Panes(1).Activate Range(board).Select ActiveCell.FormulaR1C1 = Sheets("IMPORT").Range(from).Value Next x = x + 2 End Sub
The other part is that this is a work around to the ''getting past conditional
formatting 3 limit" code that is displayed on this site.
It is not friendly at all at having a macro copy paste. I have the code do a condition check to turn off the private sub until i'm ready, but the problem is that to have it paint i have to select each cell individually, hence this looping code above to reselect the affected cells so they change to the right color.