excel & vba 2010

Hi everyone I've been working on a project and have come across a run time error and I'm not sure what's wrong. Here's the code I have Sub GenerateSummaryYee() Dim lr As Long Dim adr As String Dim jobt As Long Dim bal As Long 'Define Yee array Yee = Array("1235 Law 11-8a", "2526 Roof"...

Hello, I have created a macro to open a program where drawings are stored. I am trying to open the .pdf file that appears in this program. I need to click on the "View / Print Drawings" button but am not sure how to do this. I will not be able to just search the folder where the drawings are...

Hi All, I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format. Kindly advise...

Hi, I need a macro/vba code which can calculate the Age calculation. I mean it must calculate current date minus the different pay date in column d to column c. As i have to do it manaually on daily basis so i want to do it automatically the moment i paste the new pay dates in column d. Please...

I want the help in one of my excel dashboards where i need the automation. I have attached 3 document as per the below:- 1.My Dashboard data 2.Amit_Team Data 3.Harshad_Rec data I want the button to be set into my dashboard data file and do the following:- 1.It should open the Amit_Team Data...

Is there anyway to link this hyperlink to the sheet created in the code?? Thanks. If Me.cbStores.Value = "Northern / Northmart" Then Dim sh As Worksheet Set sh = Sheets.Add sh.Name = AddEmployeeUF.txtFirstname.Text + AddEmployeeUF.txtMiddleinitial.Text +...

I have a protected sheet for data entry but I want the user to be able to still drag and fill cells from the value in the cell above. Once I protect the sheet I seem to lose this functionality. Is there a way to use VBA to enable this functionality without removing the sheet protection? There is...

I have church that uses a calculator to spread funds and I have translated these simple formulas into excel. The issue I am having is the calculator is 2 decimal places and the Excel Sheet is 3 decimal places that occurred in a recent scenario. Calculator: If you enter into the calculator...

--- Problem 2 - Mr Excel Forum Change this formulae needed so it works in Excel 2010 version who have no datediff formula available ? Getting hundreds of client sites to upgrade in 24 hrs not possible. =IF(ISBLANK(U15), "", DATEDIF(U15,$V$3,"y") & " y, " & DATEDIF(U15,$V$3,"ym") & " m ")...

I am trying to streamline my charting requirements and need some advice. I want to export the queries I used for charts to excel and have that linked to power point. These reports are monthly and my manager would like to have these saved for historical review. So, I know I can export my queries...

Hi, All I'm fairly new to writing macros in VBA and just wanted to see if I am doing this right or if there is a better way to write this. The program is fairly simple, it cuts all data (rows and columns) starting at A13 and pastes it to the next unused row of another sheet. The macro seems...

I'd like cell E433 to total the amount of entries entered into a formula in cell F433 where the formula is: =91.72+38+292.45+38.4+81.23+43.52. Additionally, the whole E column will use this formula. Cells in F column will either have numerical entries, or will have simply have "N/A". So I'd...

Hello! I am new to excel VBA and I need a bit of help. I have a table that have columns such as ID, Name, Duration and etc respectively. Okay, so the requirements stated requires me to: Make the ID column as non-editable, which I have done by locking the ID column ONLY...

Hello, I would like to know if there is a way to lock a cell based on the content of another cell on the same line ? (this action will occur multiple times in the sheet) So far I have this but it doesn't seem to work and looks quite heavy ... I would be very grateful if somebody could help me...

Hello, I have this macro to hide columns based on the value of a cell but I would like to know how I could tweek it to make it hide 2 columns at a time ? Thank you very much for your help ! Best regards, Hippolyte Private Sub Worksheet_Change(ByVal Target As Range) Dim rMin As Integer...

I have a code error that was fine with Windows 7 office 32 bit, but with Windows 8.1 Office 64 bit.. it keep marking error at the set db = opendatabase command! how do i fix this problem. or how do i rewrite the code so it works! --------- Sub AddNewProduct() Dim dbsDuke As Database...

Hi Guys, I hope you are all well. I was just wondering if anyone would know how I can amend the below code so that it will only copy rows where the value in column D exceeds a Value of 0 any help would be greatly appreciated Many thanks jamie...

I need to look at two cells (C and F) on a each row, and if the value for C to ends with 30 and the value for F is greater than Zero, copy and paste the row to another sheet. I've managed to get the copy and paste to work using 1 criteria, but I cannot figure out how to get both criteria to work...

Guys, I want to automate a redundant task that I do every day as a part of my work. Let's say I have a file with a standard name in a Source location, then I have a destination location. I want to copy this one file and save it as let's say 10 files with different names from an excel...

Hi Guys, I currently have an order sheet for multiple customers. The AC Number goes into Sheet1 C2 and you select the product type from a drop down list in C3(the information for the list is on sheet 2 H2:H6 . ) my problem is that no matter which ac number goes into c2 you can still see all...