excel & vba 2010

I am trying to get the cell address of the min value in a range I am getting a Run-time error 424 Object required. The error is highlighted in yellow at the Set minCell line. Any help is appreciated. Sub LowHighUpdate1() Dim ws As Worksheet Dim wrksh As Excel.Worksheet Dim R1...

I am trying to clean a file with phone numbers that have put in incorrect. I have fixed many issues, text after the phone number, missing parentheses, etc. I am trying to use regex to look for a missing space after the closing parentheses ex. (978)882 What I need the code to do is add a space...

Hello, I am creating a template that starts with a time series of daily values for the past year (the specific dates will depend on what day I am updating it for). I need to be able to manipulate monthly data from the time series. I am running into issues because there are gaps in the data...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> I have a userform with a sheet (Sheet1) filled with about 20 columns of data. I want to create a button (cmd1) that when clicked will populate a list box (Listbox1) with the data...

I have tried to find how to set vba code to check each tab in a workbook when the file is opened each day, and based on some date values and other criteria, change the tab color accordingly. My macro is below, but it isn't working. It is changing some tabs blue, and some red, regardless of the...

I am using Excel 2010, and have two dropdown boxes. Everything is set the same in both, but with different named ranges as the dropdown selections. The problem is one box allows users to add additional text after the selection. The other dropdown box does not - it gives an error message when...

I have a simple Excel file with 3 columns of data. I would like to be able to allow a user to make changes to the file and have it update an Access database with the changes as well as the Excel file. I'd like to have a 'Submit' button that processes the changes to the Access database. I am...

I'm starting to learn how to work with VBA Macros and I'm in a point that a can't move on, So I have an excel workbook with some user and pass from a website, in my macro a read that values and navigate to that website using IE, after the login a want to download a pdf file, that file is...

here is how have articles in cell. <tbody> A B aaaaaaaaaaa(small line) (one enter is in this line) bbbbbbbbbbbbbbbbbbbbbbbbbbbbb(very big text content without enter) (one enter in this line) ccccccc(very small content) (one enter in this line) ddddddd(very...

Dear Friends, (step-1) I have a task to list down all the list all the files (file names) in a folder in one sheet in excel workbook. (step-2) then I am also supposed to print all the files listed as part of step -1 I am trying to achieve it by creating two buttons. (one for listing all the...

I am desperately hoping someone can help me, as I've repeatedly run into a wall for about two weeks now trying to solve this problem and I've finally admitted to myself that a solution is beyond my scope of knowledge. I should note I'm working in Excel 2010. I have an InfoPath form that submits...

Hi, Searching for a macro to pop message "Send email" based on cell (Sheet2. E1) (date and time) every 4 hours. excel 2010 ver Help will be really appreciated.

Hi, Hope someone can help me i have the following sample dataset: <tbody> Name Area Term Score AA SW Summer A AB NW Spring B AC SW Winter C AD NW Spring B </tbody> I require a pivot table from the dataset above that displays a table in the following format: <tbody> Summer Spring...

Hi, I am trying to figure out how to add an email address to an outlook email dependant on the value of a designated cell. I can generate and send the email no problem but can not seem to add a cc recipient. any ideas? Sub SendCompliants() Dim IsCreated As Boolean Dim i As Long Dim PdfFile...

Using a macro, I need to insert a text box at the current location in a spreadsheet. The text box and text will have custom formatting and will contain the same formatting and content every time it is generated. I was going to insert a pic of the text box here but I don't see that I can...

Hi, I am looking for a macro (VBA) in Excel 2010 that when applied will search in Column A to find the keywords that are predefined in Column B and those that match will be bold and red color. For the sake of providing an example below is the expected result when the macro is run: <tbody>...

Dear all, I am currently facing another challenge. I want to have a script that has the following logic: - If there is one shape, keep it centered. - If there are two shapes, move the first to the left and the second to the right by enough that they don't overlap. Resize them as well if they...

Hello I need a border after every fifth record and another border after the group. So far I can do one or the other but not both in vba (ideally) and conditional formatting. The number of columns remain the same (A-G) but the number of rows will change from week to week. The data is sourced from...

Hello guys, I have two listboxes, listbox1 and listbox2. In the first listbox the values have 3 columns with values are initial loaded. Then the user need to select items and then all values from the 3 columns need to be transferred to the other listbox2. When I try to select the items, I'm...

I'm running analysis on an Audit that has been distributed over the course of a year. There are currently about 40 or so different audits. Each audit contains 90 questions. When the audit was first published, the results we were getting were skewed. For instance, many of the answers came back at...