vba & excel 2010

Hi, I presently have coding that will create the word document but I was wondering if it is possible to have coding that will help with the formatting of the Word document and the removal of bookmarks that are no used (no information in the corresponding cell in excel) the person fills...

Hey Everyone, I have been working on a function to linear interpolate some data- I got it to where it was giving values however they seem to be incorrect. I cant find an error in the equation so far so i am not sure where to fix things. I am also extremely new to VBA to bear with me on the...

Sub D_W() Dim X As Range, Y As Range For Each X In Range("B3:g3") Set Y = Range("J5:Q10").Find(X, LookIn:=xlValues, lookat:=xlWhole) If Not Y Is Nothing Then Y.Interior.ColorIndex = 6...

Hi Folks. The code I am loading here is about to make calculation in the range ("B4:B18") "BUT" now I need to test the code in different ranges, example B4:B10, and after maybe B4:B22 and keep testing different ranges, so the "FAVOR, PLEASE" I need is type on ("I1") the start, and ("J1") the...

Hi. I have a dynamic array at B3:G2650 and in A3:A20 the numbers from 1 to 17. The double-code uploaded here return the coefficient trend line results at J3:Q10 respectively in this frame and the other just highlight the first row of the array on the report. Until here everything is fine. The...

Hello folks. PLEASE, I have a macro, and I see some kind of loop concept to apply here but still thinking, so PLEASE somebody can give me a hand here. Sub Coe_fficient_trend_line() Range("P5").Formula = "=TRUNC(TREND(B3:B20))" Range("P6").Formula = "=TRUNC(TREND(C3:C20))" Range("P7").Formula...

I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs...

Hi there, I am stumped as to how to construct this part of my IF formula Column F25 = 333,000.....G25 = 100,000 F26 = 100,000.....G26 = 333,000 F27 = 20,000.......G27 = 0 F28 ....................G28 F29 ....................G29 F30 ....................G30 This is my attempt but it's returning...

Hi there, Can anyone help me amend this VBA code to include more than one reference (if possible)? It currently refers only to D12 but I want to add another nine references - D68, D124, D180, D236, D292, D348, D404, D460 and D516. Thank you! Private Sub Worksheet_Change(ByVal Target As...

Hello folks I have been trying to work around this code, I need some hands on here, Please. I am trying to generate all possible combinations and permutations possible from the set of numbers from 0 to 9 taken four at a time BUT display ONLY the one’s that match the conditions. The condition...

Hi, I have the below code which works fine if the target "No._Partners" is on the same sheet. However, in this case, "No._Partners" is based on another sheet. Can someone please help me change the first part of the code to refer to another sheet? I'm not quite sure how to do that.. Thanks...

Hi there, I have 3x Form Check Boxes. If any of them are ticked, I would like sheet "Dairy" to be visible. If none of them are ticked, sheet "Dairy" should be hidden. I have linked the 3x check box references to cells P1, P2 and P3. In P4 I have the following formula...

Hello. This code do not give me any error return; but do not give me the right results either. I am trying to get the total of oranges sold only, on "C1". My data Fruit's names A, and quantity sold B and this is the code I tried. Sub Fr_Sd() Dim LastRow As Long...

Hello. I have a dynamic array B2:G2600 (6 columns), on Col "M" would like to see how many odd numbers there are in the rows, and on Col "N" the even numbers. So I workout first with the macro recorder, ("this is a short version as example, only"), Sub CORR_ECT()Range("H2").Select...

I have an Excel sheet with over 21,030 records (rows), that need to match against a List sheet with by two criteria. Criteria 1 = WUC and Crtieria 2 = POS. How can I vet the list to show only the listed criteria items? Also, list the criteria items not in the list being vetted? The List...

Hi, I'm trying to hide a command button if cell D8 does not equal 1, 2, 3 or 4. D8 is a dropdown, so changes manually. I have the following code below (which may or may not work) but I'm having difficulty including it with my other code (also below) as I keep getting errors. Can someone help me...

Hi I have an input column with the date of input at the top and number values on each row of that column (30 no.). I then have a table of weekly dates horizontally in another section of the worksheet. What I need is to copy the data from the input column and paste the values into the...

Hi! So i have a data set that is exported by a database, so can't change it's format. I have a script to copy and paste it into my sheet and it works fine: 'set the range reference variables Set Bk = Sheet3.Range("C5") 'file path of book to import from Set Sh = Sheet3.Range("F5") 'sheet to...

Hello. I wish a real good weekend for all. I am loading the macro for the all coefficient trendline, first need to be editing (loop require), and the real point for me is to be able to write the range of "X and Y" variable for the all formulas from the location J1 and K1, I would like to be...

Hello, a real novice here so excuse the probably simple question but I cannot locate an answer. I have a master workbook which contains lots of file paths to other workbooks. These locations change every month so to get around it I have a sheet which automatically updates the file paths each...