• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Change line of code to refer different columns

paradise

Member
Hi,
I want to change the below line of code
Code:
    For Each cell In Range("A2:CX" & Range("A1").SpecialCells(xlCellTypeLastCell).Row).SpecialCells(xlConstants, xlTextValues)
To,Range like -A:A,K:K,AJ:AJ ,T:T,X:X
 

paradise

Member
Am I right in syntax as I want to change range as :

Code:
For Each cell In Range("A:A","K:K","AJ:AJ","T:T","X:X").SpecialCells(xlCellTypeLastCell).Row).SpecialCells(xlConstants, xlTextValues)
 

Fluff13

Active Member
Rather than asking me to look at a thread you have started elsewhere, I would suggest that you take the time to read the rules.
 

vletm

Excel Ninja
paradise
These are for You too:
 
Top