$$Excel-Macros$$ Range issue when trying to fill formulas inside a loop

Hi, I have a set of columms, each containing formulas. I want to loop through these and fill down each time. This is what I have at present: Sub fillRecon() Dim MY_COLUMN As Integer LastRow = limit ' formula finding the number of rows in a worksheet.

$$Excel-Macros$$ Test Mail

just checking if i can send a mail or not. i had sent a reply to 1 post but i cant see my reply. i dot know whats wrong. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

RE: $$Excel-Macros$$

You have to open up Visual Basic from toolbar and paste in Ashish's coding in the module. Then save. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jeannie Sent: Wednesday, May 25, 2011 8:30 AM To: MS EXCEL AND VBA MACROS

RE: $$Excel-Macros$$ How to filter only the required information using VBA codes?

thanks From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, May 25, 2011 7:18 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to filter only the required information using VBA codes? hi check the

$$Excel-Macros$$ Re: Test Mail

When you reply to a post the moderators must approve it before it will appear. The delay in your reply and when it shows varies. On May 25, 3:16 pm, hanumant shinde arsfan2...@yahoo.co.in wrote: just checking if i can send a mail or not. i had sent a reply to 1 post but i cant see my reply. i

Re: $$Excel-Macros$$ Re: Test Mail

Thanks but i was able to send the mails i just missed it so i thought its not getting delivered. thanks anyways :) - Original Message From: JsinSk jsin...@gmail.com To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, 26 May, 2011 12:41:26 PM Subject:

$$Excel-Macros$$ Dates in Excel

I have a column of various dates that have the incorrect year, for example: 9/1/2011 12/17/2011 10/31/2011 etc, etc... The year should be 2010 not 2011. Is there a quick remedy to correct this problem for several hundred dates? The Month and day are correct - just not the year. Any ideas? --

$$Excel-Macros$$ Intuitive Macro that changes based on cell value

I don't know if this is possible but I am hoping so. I run several performance reports daily and weekly. On Monday's I have to run the reports twice, once to compile the prior week recap and the second time to produce the current weeks performance. Currently between runs, I have to archive the

Re: $$Excel-Macros$$ Dates in Excel

Assuming that you r date is in Cell A1 Convert them with this formula: Formula in B1=Date(2010,Month(A1),Day(A1)) On Fri, May 27, 2011 at 12:49 AM, Rich Prince rich.pri...@gmail.com wrote: I have a column of various dates that have the incorrect year, for example: 9/1/2011

Re: $$Excel-Macros$$ Dates in Excel

Hi, You can select all the dates and use Control + H Find What: 2011 Replace With: 2010 then click on Replace All button. It will change all the 2011 to 2010 Hope this helps! Thanks, Shreedar On Thu, May 26, 2011 at 11:19 PM, Rich Prince rich.pri...@gmail.com wrote: I have a column of

$$Excel-Macros$$ Re: Urgent:: Is there a way out to increase the cell character limit to beyond 255.

Hi All, Looking forward to your reponses. Rgds, Bharghav Ramdas On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas bhargha...@gmail.comwrote: Hi All, I am currently working on an excel (2003)sheet whose cell character length is beyond 255. I am able to copy just 255 characters. The remaining