Question: I have a sheet where I want to change the value in a range of cells in a different column than my selection. I use VBA because it's part of a code that sends information to a certain printer. I would like to let the macro also show that the selection has been printed.

**To clarify:**  

- When I select F4:F10, I want the cells G4:G10 changed to a text value "Yes".  

- When I select F4:F15, I want the cells G4:G15 changed to a text value "Yes".

I've searched the forums and I found/made the following:

```
Sheets("INPUT").Select
ActiveCell.Offset(0, 1).FormulaR1C1 = "Yes"

```

That works perfectly fine, however it only changes the value of one cell and not a range of cells.

Is there a way to change a range of cells to "Yes" instead of just one cell?

Answer: 
Try 

```
Selection.Offset(0,1).Value = "Yes"

```

This is where `Selection` is your range selected. This is offset by 1 column and has value of `"Yes"` assigned in one go.
I got it working perfectly thanks to the above replies. Much appreciated!

I'm not sure how to close this thread or if that's nescessary, but "Case closed"