The range i want to use is in the below R1C1 format. How do i use it to put a value into the cell.
Myrange = sheets(1).range("A1").address(referencestyle:=R1C1)
Myrange = "value" (not working.)
The range is actally used in a loop with many conditions and vary by conditions. I dont want to write the whole conditions once again just to put a value in a cell.