-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cls
-
A
Copy from Array and paste to different array
Hi guys, what am i doing wrong here ? Private Sub CommandButton1_Click99() Dim LR As Long, i As Long, cls cls = Array("B2", "D2", "C2") With Sheets("Sheet2") LR = WorksheetFunction.Max(2, .Range(Array("H1", "K1", "Z1"))) For i = LBound(cls) To UBound(cls) Range(cls(i)).Copy...- AbdulkareemAlhassni
- Thread
- cls end long rangeclsi.copy uboundcls
- Replies: 3
- Forum: Excel Questions
-
J
Deleting rows based on the dates condition
Hello, I have two tabs in by spreadsheet. "Report" and "Holidays". In the first tab I have data and one column contains dates (format: mm/dd/yyyy). Also, in column A of Holidays tab I have listed several dates. I would like to delete all rows from tab Report which are holidays listed in the...- johnabrosky
- Thread
- cls dates holidays rws tab
- Replies: 1
- Forum: Excel Questions
-
B
copy to new sheet based on column change
hi i have the below code Sub sheets_from_colb()<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Const cl& = 3 Dim a As Variant, x As Worksheet, sh As Worksheet Dim rws&, cls&, p&, i&, rr&, b As Boolean Application.ScreenUpdating = False...- BORUCH
- Thread
- cls code end sheet true
- Replies: 0
- Forum: Excel Questions
-
S
additional condition in vlookup
currently i am using the below formula for in between range but i want add an additional column (type) for verifying how can it be done =VLOOKUP(G2,B:D,3,TRUE) <colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody> TYPE FROM TO CLS TYPE DATA CLS AA...- sachin483
- Thread
- add additional cls range type
- Replies: 7
- Forum: Excel Questions
