vba programming

  1. kelly mort

    Check if a pdf reader is installed on a pc

    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...
  2. kelly mort

    Building a sentence generator with VBA

    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 {...
  3. D

    Vba Programming

    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...
  4. montecarlo2012

    workbook require (trendline coefficient)

    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...
  5. A

    Import the data from EXcel

    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...
  6. A

    Excel VBA Code Problem

    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?
  7. montecarlo2012

    (vba) adding an input

    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...
  8. montecarlo2012

    (vba) looping frequency function

    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...
  9. montecarlo2012

    (vba) loop concepts

    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...
  10. montecarlo2012


    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...
  11. montecarlo2012

    adding array

    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...
  12. P

    Merging Columns based on two criteria

    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...
  13. montecarlo2012

    trunc function

    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>
  14. S

    Counting highlight values

  15. C

    Highlight duplicates row by row (not columns)

    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...
  16. montecarlo2012

    Looping through a multi dimensional array

    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...
  17. montecarlo2012

    time card problem

    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...
  18. montecarlo2012

    (vba) Sub headingsInsert() how work

    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...
  19. montecarlo2012

    snippet code for sum two values

    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
  20. M

    From macros to vba (substractions)

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back