$$Excel-Macros$$ Re: Automating the MIS

Surely I can help you out on this, but I would need one information, what would be the sheet name of the workbook. Thanks, Mukesh On Thu, Mar 5, 2009 at 7:54 AM, Roopesh Kapur wrote: > > Hi Everyone, > > I need some help from you all, my requirement is that there are 11 people > in > my team and

$$Excel-Macros$$ Re: VBA Form Auto Sizing

Hi Kanwaljit, I've posted your solution, please check this link: http://www.excelitems.com/

$$Excel-Macros$$ Re: problem decomposing cells (urgent)

Hi Mehdi, Try this code: (Changes highlighted in Red) [code] Dim Rng As Range, Dn As Range, oVal, oSp As Long Dim Ray, c As Long Set Rng = Range(Range("A2"), Range("A" &

$$Excel-Macros$$ Automating the MIS

Hi Everyone, I need some help from you all, my requirement is that there are 11 people in my team and each one uses a different workbook as theri MIS at the end of the day I have to combine data from each ones MIS into a master MIS. Few Points. 1) All the workbooks are saved in the same location

$$Excel-Macros$$ Re: For Each loop creates 1004 error

Hi AI Your code is working fine on my system. Please re-check by closing and opening the file. However it doesn't matter much by try this 1. Make S capital - i.e.take care

$$Excel-Macros$$ Re: vba vlookup

Hi Buddy, Here is your Solution, Try this instead of what you were doing before: *amount = Application.WorkSheetFunction.VLookup (R1C2,[Garnishment_2009_4.xls]Sheet1!R3C1:

$$Excel-Macros$$ Re: IF Function

Hi DM, I've posted your solution, please check this link: http://www.excelitems.com/2009/03/ceiling-and-floor-function.html For more tips, tricks, downloads and proble

$$Excel-Macros$$ For Each loop creates 1004 error

Given this code: totalRows = Worksheets("sheet1").UsedRange.Rows.Count For Each r In Worksheets("Sheet1").Range(Cells(3, 4), Cells(totalRows, 4)) VBA gives a 1004 error immediately (does not enter the loop) on the For Each line - this confuses me because: 1. There is a "Sheet1" worksheet 2. The

SV: $$Excel-Macros$$ Find next available row

Hi Dim LastRow as double LastRow = .Cells(Rows.Count, "C").End(xlUp).Row LastRow = LastRow +1 This count colum "C" change to the colum you want Regards Yngve -Opprinnelig melding- Fra: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] På vegne av iwasinnihon S

$$Excel-Macros$$ IF Function

Ok, can someone help me out? I am trying to create formula that is going to round my numbers to x.47 or x.97. A1=$9.99 B1=75% C1=A1-B1=$2.49 So what I am trying to do is to take discount from price and if it ends x.49 I would like to round it x.47 and if it ends x.99 I would like to round it to x

SV: $$Excel-Macros$$ double variable on a formula

Hi Try 27.7 not 27,7 -Opprinnelig melding- Fra: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] På vegne av Nwt Sendt: 1. mars 2009 21:13 Til: MS EXCEL AND VBA MACROS Emne: $$Excel-Macros$$ double variable on a formula Hi all, i'm trying to insert a formula by vb

$$Excel-Macros$$ vba vlookup

I am trying to do a vlookup in vba, save the results in a variable and then place the value in a cell. I used to have the vlookup as a function for the cell: Cells(LastRow, 2).FormulaR1C1 = "=VLOOKUP(R1C2,[Garnishment_2009_4.xls] Sheet1!R3C1:R100C4,4)" However, I don't want it linked, I just wa

$$Excel-Macros$$ Re: Find next available row

If the next available row is the first blank row on the spreadsheet you can use this: iNextRow = Worksheet("MySheetName").Range("A65535").End(xlUp).Row + 1 Worksheet("MySheetName").Range("A65535").End(xlUp).Row returns the row number for the last row in column A with data in it (you can change t

$$Excel-Macros$$ Re: Find next available row

I asked this question to soon. Right after I posted the question, I found the answer. On Mar 4, 8:38 am, iwasinnihon wrote: > I am writing a macro and would like to have it find the next available > row on a sheet, enter the date, do a vlookup, and enter a running > sum.  I can do everything ex

$$Excel-Macros$$ Re: Find next available row

How do you define "next available row" ?? Is your spreadsheet filled with no blank rows and you're looking for the last row? or does your sheet have blank rows in the middle of data? If the first is true (no blank rows) There is a couple ways to do it. the way I like is to use a Worksheet Functio

$$Excel-Macros$$ Find next available row

I am writing a macro and would like to have it find the next available row on a sheet, enter the date, do a vlookup, and enter a running sum. I can do everything except find the next available row. How would I do this? --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Re: By Macro-Draw charts from Excel to ppt

http://www.computing.net/answers/office/paste-excel-graphs-to-powerpoint/7040.html On Tue, Mar 3, 2009 at 7:11 PM, Nassa wrote: > > Hi all, > I have a table on Excel like below table, and I want to write a macro > to draw charts and graphs in power point. > I don't know how to write such a m

$$Excel-Macros$$ Re: By Macro-Draw charts from Excel to ppt

Hi All, I am creating a spreadsheet for day trading in the stock market. The data source is from web through excel web data query. This is how the data looks like *Col A* *Col B* *Col C* *Col D* *Col E* *Col F* *Col G* 2700 155894 215222.58 62.3 4653450 =% Change (Col D) =% Change (