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
Display More
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.
Any ideas?