jeudi 17 mai 2018

Excel If statements for UsedRange only?

I have a macro set up in Excel which takes some pasted data and parses it out into a new sheet. From there, I'd like it to read if a value exists In any cell in column K, and if so, places a value on my first sheet into the same row but in column Q.

A bit confusing, I'm sorry. I've tried

If Range("K:K") <> "" Then
   Range("Q:Q") = ("Input!R2C2")
End If

But like it reads, it fills data for the entirety of column Q. I want it only to fill in data where a value exists in column K.

Aucun commentaire:

Enregistrer un commentaire