Search results

thanks Solved Add -1 to the last of for For i = 0 To listSearch.ListCount -1

Why repeat the last Excel sheet row twice the code is good but repeat the last row how to prevent from pasting the last row twice For i = 0 To listSearch.ListCount If listSearch.Selected(i) = True Then ActiveWorkbook.Sheets("Database").Activate...

did you forget apply your change you paste same code just remember your

I changed the code but also display this error If UCase(C.Value) & "" Like "*" & UCase(txtSearchABBACCT.Value) & "*" And CDate(Worksheets("Database").Cells(i, 2).Value) >= CDate(Me.txtFrom.Value) And CDate(Worksheets("Database").Cells(i, 2).Value) <= CDate(Me.txtTo.Value) Then

(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)(y)

:) what should i do?

Hello the problem does not add an item the problem does not get the correct data

I want subtract to cell using VBA but not work Application.ScreenUpdating = False Dim lr As Long lr = Worksheets("Database").Range("C" & Rows.Count).End(xlUp).Row Dim i As Integer For i = 2 To lr Worksheets("Database").Range("W" & i).Value = Worksheets("Database").Range("T", i).Value -...

how can I format range special phone number what is the code Worksheets("Database").Range("N" & i).NumberFormat = Special Phone Number

when Adding from and to the text box to the code not work this line And CDate(Worksheets("Database").Cells(i, "B").Value) >= CDate(Me.txtFrom.Value) And CDate(Worksheets("Database").Cells(i, "B").Value) <= CDate(Me.txtTo.Value) Then On Error Resume Next listSearch.clear If...

friend I have a list with true false from Excel I want merge field «Disclosure_Required» change true to Yes and false to No In word How can I do that I can edit merge field in word just give me the formula thank you so much

hello friends Have a great day explaining my problem in excel attached ========================== if an entire row duplicated Not included version ========================== Thank you so much in advance

Thank you so much for your help and assistance I will check the project

Hello friends I need to transform the attached table to new table You will see explain in Excel Source Table Transform Table How can I do that using query Thank you in advance for your help

Working with Online MS SQL is good because I don't need a Team viewer. work any time I prefer asking the client about DB is Online or Local Not good (I think) Show you that you don't have any experience

I don't have a specific connection string if possible general rules

Can you explain more

Hello Is there any easy way to know if MS SQL DBis hosted locally or online host Thank you so much

Thanks (y)(y)(y)(y)(y)(y)(y)(y)(y)(y)

Private Sub Command2_Click() On Error Resume Next StrListItem_ = "" Dim ctl Set ctl = Me!List0 Dim i As Integer For Each varItem In ctl.ItemsSelected StrListItem_ = StrListItem_ & "," & Me.List0.ItemData(varItem)...