excel vba 2007

Hi I am not able to progress after getting output got cell J11. Looks like the loop isn't working. I am looking to get the month end dates in the row 11 from the start date to end date. Can any one please help me to resolve this?

Important - Kindly help in the solution of this simple VBA Macro excel task?

I am trying to extract the image from url and embed in excel 2007. My Excel is simple , it contains 2 columns , Column 1 has the image url and in other column i want the embed the image. i am using the attached code , it is working perfectly fine for first row where i have saved the image from...

Hi , i have data in column A, B ,C but i need to insert new row above active cell in coloum B original format <colgroup><col><col><col></colgroup><tbody> A B C 4 APPLE SUGAR MILK WATER 5 BANANA SUGAR MILK WATER 10 MANGGO SUGAR MILK...

I want to test a condition and if its true then i want to store that index for which it is true in an array. But the array isn't taking up values. My code: Dim yridx(50, 2) As Integer For i = X To 1 Step -1 If (Year(Range("A" & i).Value) <> Year(Range("A" & j).Value)) Then...

Hello rick i have some text files in a folder i want to extract some data text from these files to excel i want to extract some text after pppppppppp word and before aaaaaaaaaa word.. suppose in my text file pppppppppp 4547697864 aaaaaaaa is my text file and now i want to extract data...

Hi All! I'm trying to do a find and replace but I would like to replace the contents with a Cell value, there are around 500 cells that need this doing so i'm trying to think of a way to do it using the cell value as a variable Basically one of the example are below...

I am trying to find a way to check all values entered into a specific column to ensure that all values are a valid mmddyy date. The column will be of text type, so there is the potential for this column to contain any values. I am not sure if there is a more elegant solution but out of the...

At the moment, I am searching on one column. But I am stuck on how to search on two or multiple fields to bring up more of a specific result. I am trying to narrow my search down from 1 to 2 to bring up more specific data. Can anyone help. Thanks in Advance. Appreciate the help...

Hi All, I would be really grateful for some help on this one (Excel 2007 onwards) I have two worksheets, 'Analysis1' and 'Support'. 'Analysis1' is generated from a number of sources, and I have no problem in getting the data into it. The number of columns in this worksheet can vary, but the...

I'm trying to create a change log for 2 different sheets in this workbook. My first one works using: Dim irow As Long Dim icol As Integer For irow = 1 To 65536 For icol = 1 To 6 If Worksheets("Extra Opener Schedule").Cells(irow, icol).Value <> Worksheets("EOS").Cells(irow, icol).Value...

I have this Excel VBA code to edit response of Google form, this code is working for one url but how to edit all existing response with excel until the last empty row. Any help will make my day.. I am working from 2 to 3 days for the same and search forum but no solution. I am attaching excel...

Hii!! I have two columns in my worksheet where i have to move shapes inserted anywhere in column 1 to column 2. whenever i do so i want a userform to appear in my sheet. There is only one text box and one submit button in userform. whatever data i insert in that textbox that gets saved in sheet3...

I want this macro to run after every 3 seconds so that each time i move a selected shape among many shapes its color should change. But this code only works once... It doesn't repeat or doesn't change the color of next shape i select and move to particular position. Public RunWhen As Double...

I have data in column D:D Header value is Source: I have to align the values proper format like My target is CSV File But it has like CSV or CSV_File or CSV File so it got mis appropriate values of text in col My target is CSV File from where find CSV 2nd target is Manual - CBT from where ever...

dear experts i have set of data need to compare with first 3 way lookup result with child series and description. lookup value is COUNTRY and DSERIAL and GCOA PARENT result should be match with masterdata file if not match replace by new value. for e.g COUNTRY = Luxembourg DSERIAL = 10004...

Dear sir I want to group by Column A (i.e. Item) and Column N (i.e. length) and also want to add the sum total of each change in lengths of column E,F,G,H,I,J In the column K subtotal of E:J lenghts of column & want to add the average of L,M,N Pls find the attachment what i looking for

Hello, I am assigned the task at work to transfer the data from the excel documents into the word document for the final proposals. We have been doing this without a VBA Code, this is quite time consuming process. The clearest way we found to transfer the data from excel is by in the word...

OK, a vague enough question I am sure, but this is my predicament : If I run my VBA program I get an error message "Argument Not Optional" ... but if I debug I get the message "Can't execute code in break mode" !! My main VBA is in Thisworkbook and the new code is as follows ...

Hi, I'm trying to close all the file except the macro file. But it closes all the files including macro file. Any help / clarification would be appreciated. Sub exceptwb() Dim wb As Workbook Application.DisplayAlerts = False For Each wb In Workbooks If wb.Name <> ThisWorkbook.Name Then...