oh right right....
great thank you!
oh right right....
great thank you!
In the code below:
What does the "&" mean in ws.range("A2:F" & LR)? Is it like the word AND?![]()
For Each ws In Worksheets LR = ws.Range("A" & Rows.Count).End(xlUp).Row ws.Range("A2:F" & LR).Copy Me.Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial xlPasteValuesAndNumberFormats Next ws LR = Range("A" & Rows.Count).End(xlUp).Row With Range("A2:F" & LR)
Same thing with [code] With Range("A2:F" & LR)?
Also what does the following code do?
thanks![]()
.FormatConditions.Add Type:=xlExpression, Formula1:="=MOD(ROW(),2)=0"
Last edited by Lifeseeker; 02-21-2012 at 09:48 AM. Reason: few more clarifications needed
Figured out what the last line do. It is for alternating row colors.
Still need an answer to my first question though.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks