To change syntax of [a17:M17].Borders(Var(brdr)).Weight = xlThin to [A & rw & :M" & rw ].Borders(Var(brdr)).Weight = xlThin

[SamDsouza]

Hi Can someone help me to obtain the correct syntax for the following

Dim brdr As Long
Dim Var As Variant
dim rW as Long

rw = 17

Var = Array(xlEdgeLeft, xlEdgeRight, xlInsideVertical, xlInsideHorizontal)
For brdr = LBound(Var) To UBound(Var)
   [a17:M17].Borders(Var(brdr)).Weight = xlThin  
Next brdr

Want to change for below syntax

[a17:M17].Borders(Var(brdr)).Weight = xlThin

to

" [A" & rw & ":M" & rw &" ]".Borders(Var(brdr)).Weight = xlThin

SamD
144

 

[MARK858]

Try

Range("A" & rw & ":M" & rw).Borders(Var(brdr)).Weight = xlThin

 

[mole999]

Mark858 beat me too it, but leave out the double dot

 

[MARK858]

Mark858 beat me too it, but leave out the double dot

Edited thanks, Bad copy and paste

 

[SamDsouza]

Dear Sirs,
Thank you so much

.Range("A" & Rw & ":M" & Rw).Borders(Var(brdr)).Weight = xlThin
Edited thanks, Bad copy and paste

Mark858 Your Syntax is absoluetly right with ":" much required
Rather Efficient, Excellent "Copy and Paste"
else trying
Mole999's suggestion we get error using without ":"



Thanks
SamD
145

 

[MARK858]

Mole999 suggest get error without ":"

@mole999 wasn't talking about the : , there was a double period after the range that I edited to a single period.

Happy that you have it working and thanks for the feedback.

 

[SamDsouza]

Though you guys are masters in techincal terms and coding . BTW what would be double period mean against the single period. just for the knowledge for this thread.

SamD
146

 

[MARK858]

BTW what would be double period mean against the single period. just for the knowledge for this thread.

You would get a syntax error and so the code wouldn't run, it was there purely because of a pasting error as I tested without your array variable.

 

[mole999]

Though you guys are masters in techincal terms and coding . BTW what would be double period mean against the single period. just for the knowledge for this thread.

SamD
146

range().. dosen't work only singles

 

[SamDsouza]

Thanks for the clarifications

SamD
147