res

Hello Excel Forum I want to add column headers to the first row in the array so how can I not lose their data Sub RevisedLoadArray() Dim DBA As Object, RES As Object, SQL As String Dim Name_Sheet As String Set DBA = CreateObject("ADODB.Connection") Dim My_Array() Dim Ar Dim i, ii, C As Long...

Good Afternoon all, I have a VBA macro that allows for data being entered into a text box to be placed in specific areas of my sheet. However, when I click "OK" with no value entered (blank), it ends the sub. I need the sub to stop running when it finds a blank value on the sheet, but when no...

Hello, I am trying to update when users change one or group of cells within a range when there is a space to replace with an underscore. It is working, however with a group a cells, perhaps like copy or control enter, the values only update after you click on each cell. Works okay when one...

Hi all, I would like to use a VBA code so that to “revise” the numbers in col. “J” if the account in col. “E” is “450102 ADMIN”, “450102 RES”, “605102 ADMIN” and “605102 RES” Therefore, that should make the proper deduction and then should turn the negative number into positive. Below I present...

OK I am having trouble with an IF LOOKUP formula SHEET 1 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q 1 2 #000000[/URL] "]Product #000000[/URL] "]Lot #000000[/URL] "]Subdivision Stage #000000[/URL] "]Classification #000000[/URL] "]Quality #000000[/URL] "]Type...

I have the following code that I need to modify. Certain members do not want their address and phone published in our annual directories - they want to be excluded. I have a do not publish sheet which will prevent their personnel information from being printed. what I would like to do is have...

Hello, I have a problem. I'm scrapping information from internet but when I place this info into cell It has a lot of break lines <tbody> " MLS Number Category Status Status Date Price 7068423 RES Temporarily Off Market 11/14/17 $150,000 6735873 RES...