$$Excel-Macros$$ For Each..Next . Help finding a number in data

Hi All I'm trying to write an excel vba code that return a number with respct to the value of the 2nd number. There are 5 number copied into one column(it has to be one column,project requiremnt) and if the value of 2nd number in cell1 is -995.25 and 2nd number in cell2 is > 1 it returns the

Re: $$Excel-Macros$$ Date doubt

First Approach This function is to find first Friday on every given range, is this match to your requirement ? if not, please reply with data and date as you want on each range. Confuse on this statement "month from last Friday to last Thursday of the month.", sample data needed. Function fin

$$Excel-Macros$$ Please help us with this Excel collaboration survey and win $50 Amazon gift card

Hey Microsoft Excel users! We are interested in how you use Excel in your professional life. Take this survey for a chance to win one of five $50 Amazon gift cards! Survey Link: https://www.surveymonkey.com/s/excel_survey2013

$$Excel-Macros$$ Date doubt

Hi friends, i have a query for arranging dates in a pattern. Pls help me solve my query. Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R

Re: $$Excel-Macros$$ Macro for Concatenate

You're welcome, i'am glad you've got it. Pada 25/07/2013 14:21, Prafull Jadhav menulis: Dear Sir, Thanks a lot and lot ...for explain the below code in smooth manner. I have started practice on Macro from last 3 Month. Dim i As Range For Each i In Range("A2:A" & Sheet1.UsedRange

Re: $$Excel-Macros$$ Macro for Concatenate

Dear Sir, Thanks a lot and lot ...for explain the below code in smooth manner. I have started practice on Macro from last 3 Month. Dim i As Range > For Each i In Range("A2:A" & Sheet1.UsedRange.Rows.Count) > i.Offset(, 2) = i & "|" & i.Offset(, 1) > Next > End Sub > This new