vba programming

I have been searching the Web for solutions. I have seen a few examples of how to check if an Adobe Reader is installed but what I want is to be able to check if any pdf reader at all is installed. This from excel forum...

Hello geniuses, I have this challenge here that is staring at me for a while now. I have tried to ignore it but it still pays me visit. I want to be able to use a VBA script to construct grammatically correct sentences. For the start, I will be constructing just simple sentences. S + V + O {...

in my combo box i have selected a range as a drop down to show but the range has multiple duplicate entries how to combine the same values to show as one in the combobox right now range is like this indirect costs indirect costs indirect costs sitework sitework sitework concrete...

Hello everyone, please, if somebody has the workbook corresponding to the trendline coefficients written by Tushar in his site ("http://www.tushar-mehta.com/publish_train/data_analysis/16.htm), at the end he has the code, but I need to see the spreadsheet, where is the inputs and outputs...

Hi Guys, I have a button in Access Database, but i don`t have a functionality. I need whenever i press "Import Button" it will automatically open the filer and i will navigate to select multiple files of excel anywhere in my hard drive. when i import the data it will automatically import all...

Hello...... Can you all tell me please how do i select one sheet from 2 sheets in excel. For example: I need to select to search for a name of sheets from 3 sheets. Worksheets("Seet2" or "Seet4") Can i do like that?

Hello, I am uploading a code, but I would like to be able to enter the range I want every time. the code loop the frequency function all the way down an array at B2:G2066. work good but I need to explore different ranges, the range the code has is 18 row every time it run, so would be good at A1...

Hi every one A picture isworth a thousand words, agree, I upload a picture . [image missing] I am in the chapter of LOOPS, but I don’t see what I really need. How to loop the “frequency function” in VBA; I didn’t see nothing like that anywhere, I have and array and I would like to have...

Hello. what kind of reasoning I have to apply, to understand how from the simple loop code here: Sub looptest()<o:p></o:p> Dim i As Integer, j As Integer<o:p></o:p> For i = 1 To 6<o:p></o:p> For j = 1 To 6<o:p></o:p> Cells(i, j).Value = i * j<o:p></o:p> Next j<o:p></o:p> Next...

SWAPING THE VALUESFROM THE FREQUENCY REPORT.<o:p></o:p> Manually I used the frequency function to know whatfrequency every number in every row has.But NOT including the row right above. I mean, the first frequency is B3:G21and the row to be swap is B2:G2.<o:p></o:p> The row B2:G2 is...

hello everyone. I am trying to understand about loops, so I want to see, what loop to use if I need to sum an array row by row, I am learning by myself. I want to see if you use, for...next or do while or ???. . <colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> 1 2 3...

Dear all,. I'm fairly new to VBA programming. I would like to merge 7 columns if two conditions are meet. Start Week Ending week Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec 7 11 7 11 12 1 53 1 1...

Hello, I know if I use trunc function is to avoid decimals, so I am trying to write a code, and I have this line Range("J" & lRow) = Cells(lRow, "I")/ 6 HOW TO AVOID THE DECIMALS in this case. thanks for any help. <o:p></o:p>

HELLO, PLEASE, I NEED TO COUNT HIGHLIGHT VALUES, VERTICALLY AND HORIZONTALLY, IS AN ARRAY. THE EXAMPLE HERE IS REALLY SMALL BUT MY DATA IS H1:M36 HERE IT IS MY EXAMPLE. <colgroup><col width="64" style="width: 48pt;" span="9"> <tbody> H I J K L M N O 1 1 2 3...

Hello, I need to highlight duplicates row by row (NOT BY COLUMNS), to compare two arrays. I trying countif and conditional formatting and avoid the absolute value, but, I have to go row by row, So, there are another function or maybe a vba code for it. here it is my tow arrays...

Hello everyone<o:p></o:p> Step 1- I used trunc(average(A2:A5))<o:p></o:p> Step 2- I compare the results against A1:G1<o:p></o:p> Step 3- I count how many duplicates I found in this way<o:p></o:p> And again start steps 1 trough 3, with the next line I meancompare the average of the A3:A6 against...

Hello, I would like to see how to make my time card on vba, example: <colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="64" style="width: 48pt;" span="3"> <col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt...

Hello everyone. I am trying to make a little changes in a code but here in the headingInsert when I try to change the cell D1:Q1 and the cell I:I for another position then desapear. for me looks like seal unit, I can change nothing. please somebody can explain me how can I make any change I want...

happy new year all. I would like to see a snippet code for adding two simple cells, I would like to write a number in A1 and another in A2 and get the result in A3

Hi, everybody Happy new year to all. I would like some code for some substraction that I need. <colgroup><col style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;" width="32"> <col style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;" span="6" width="21"> <col...