Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

I can get a little further my code has the error indicated on the For index line. tmprange does return with the correct range value. The UsedDataRange function is below my code Set tmprange = UsedDataRange(Sheets(RawData), True) For index = 2 To Sheets(RawData).tmprange.Rows.count this

$$Excel-Macros$$ Cell size increase

Hey Friends, I need a macro through which a cell will automatically get bigger if it is edited more than two times followed with a popup. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

make your second line For index = 2 To tmprange.Rows.count On 19 April 2012 16:47, Domain Admin domainqu...@gmail.com wrote: I can get a little further my code has the error indicated on the For index line. tmprange does return with the correct range value. The UsedDataRange function is

Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

A. That works though I still have to see if it solves the usedrange problem B. I should have known that. I have been told so before C. I still don't get why it can not be done without the set and then use the qualified values even if that is not the best way, but the function itself fails

$$Excel-Macros$$ Re: Best resource to learn MS SQL queries

A good place to learn SQL queries (not just MS SQL) is at http://www.1keydata.com/sql/sql.html. On Tuesday, April 17, 2012 5:04:03 AM UTC-7, Amit Desai (MERU) wrote: Dear All, Can you please let me know the best resource to learn MS SQL queries? Best Regards, Amit

Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

Sent on my BlackBerry® from Vodafone -Original Message- From: Domain Admin domainqu...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 19 Apr 2012 00:11:35 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ What is left

Re: $$Excel-Macros$$ Best resource to learn MS SQL queries

thanks buddy   From: Rajan_Verma rajanverma1...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, April 18, 2012 7:46 PM Subject: RE: $$Excel-Macros$$ Best resource to learn MS SQL queries You can try this:  

$$Excel-Macros$$ Re: Folder Structure - VBA Code

HI Team, Any update on the Zip files structure ? Regards, Pavan Kumar G On 4/16/12, pavan Kumar pavanshr...@gmail.com wrote: HI Group, I am looking for a VBA code to get the Folder Structure, name and type (the code also needs to get the folder structure of Zip files too) Exmpl:

$$Excel-Macros$$ Urgent - Pivot table

Dear Team Please find attached the excel workbook having a pivot table in one sheet and the relevant data in other sheet. I want to display the top 3 states zonewise in the pivot table e.g. for the zone - central, only top 3 states should be visible and similarly for other zones. Please

Re: $$Excel-Macros$$ Urgent - Pivot table

Hi, PFA, is this what u r looking for? On Thu, Apr 19, 2012 at 4:26 PM, Soni.Rajender soni.rajen...@gmail.comwrote: Dear Team Please find attached the excel workbook having a pivot table in one sheet and the relevant data in other sheet. I want to display the top 3 states zonewise in the

Re: $$Excel-Macros$$ Cell size increase

Why? Anyway, right click sheet tabview code insert thismodify ranges to suit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range(a2).Address Then _ Range(a3) = Range(a3) + 1 If Range(a3) 2 Then MsgBox Edited more than twice End Sub Don Guillett Microsoft MVP Excel

Re: $$Excel-Macros$$ Urgent - Pivot table

Dear Soni,   plz c the attached file..     From: Soni.Rajender soni.rajen...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, April 19, 2012 4:26 PM Subject: $$Excel-Macros$$ Urgent - Pivot table Dear Team Please find attached the excel

Re: $$Excel-Macros$$ Urgent - Pivot table

Dear Soni,   plz c the attached file.. From: LAKSHMAN PRASAD lakshman_...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Thursday, April 19, 2012 5:49 PM Subject: Re: $$Excel-Macros$$ Urgent - Pivot table Dear Soni,   plz

Re: $$Excel-Macros$$ Re: Folder Structure - VBA Code

HI, I was able to find the VBA code for the zip file, but its not looping till the last content, please help on this, the code has been pasted below for your reference Private Type BROWSEINFO ' used by the function GetFolderName hOwner As Long pidlRoot As Long pszDisplayName As

RE: $$Excel-Macros$$ Cell size increase

Hi, Please find the attached sheet Here I have make a dictionary object to collect Range address and Edited Frequency, then every change on worksheet I am checking the edited times if it is more then 2 , a msg will pop up. '= Public

RE: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

Try this to make your UsedRange very clear ActiveSheet.UsedRange=Empty Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of tangledweb Sent: Apr/Thu/2012 04:31 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ What is left behind

RE: $$Excel-Macros$$ Re: Folder Structure - VBA Code

Hi Pavan It is working fine with me Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pavan Kumar Sent: Apr/Thu/2012 06:33 To: excel-macros Subject: Re: $$Excel-Macros$$ Re: Folder Structure - VBA Code HI, I was able to

RE: $$Excel-Macros$$ Cell size increase

Hi Please call Procedure on Workbook open event: Private Sub Workbook_Open() CreateCollectionofEditedCells End Sub Rajan. From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: Apr/Thu/2012 06:35 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Cell size

Re: $$Excel-Macros$$ Urgent - Pivot table

Ojemeni Uzoma | Call 08060700717 -Original Message- From: LAKSHMAN PRASAD lakshman_...@yahoo.com Sender: excel-macros@googlegroups.com Date: Thu, 19 Apr 2012 05:26:11 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re:

$$Excel-Macros$$ Truncate years if data not available in Chart

Hi Dear, Please See attached book, I want to make chart for a period range, but if data not available for starting period, it must be truncate. is there any solution without VBA. Thanks Regards, Divaker -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

RE: $$Excel-Macros$$ Truncate years if data not available in Chart

Please find attached sheet I am just hiding Column if don't have data. Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Apr/Thu/2012 08:17 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Truncate years if data

Re: $$Excel-Macros$$ Truncate years if data not available in Chart

Thanks Rajan, it is good, but not solve my problem, i could not hide columns because data may for other chart on different row on same column . On Thu, Apr 19, 2012 at 9:00 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Please find attached sheet ** ** I am just hiding Column if don’t

RE: $$Excel-Macros$$ Truncate years if data not available in Chart

Hi Please see the revised version Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Apr/Thu/2012 10:02 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Truncate years if data not available in Chart Thanks

$$Excel-Macros$$ Higlight the difference

HI Team, Require a VBA code to compare the cells and highlight the difference in letters. Example: Cat - Cta TA should be highlighted Regards, Pavan Kumar G -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Re: Folder Structure - VBA Code

HI Rajan, Its working fine but there is a small concern it will not work if there is a zip files been zipped Example: A.zip contains B zip then it is not working Regards, pavan Kumar G On 4/19/12, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Pavan It is working fine with me Rajan.

Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

Thanks but I can easily clear the entire sheet. What is needed is to be able to clear a set of columns except not the header row and then paste in new column data and have usedrange be just the number of rows with the new data. I will try to see if I can use empty on the columns. On Thu, Apr

$$Excel-Macros$$ ram xls wants to chat

--- ram xls wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-3eef7fee2f-d708a7464d-N2KpHZIBXSmpNn-XvDhHYwvWYUk You'll need

Re: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

You are correct. Using that substitute function for usedrange is working perfectly though. Once I am finished I will be able to delete all the rows if I wish as another option. On Thu, Apr 19, 2012 at 12:00 PM, Asa Rossoff a...@lovetour.info wrote: I don't think Empty will have any more effect

RE: $$Excel-Macros$$ What is left behind when you clear or delete cell contents that still affects usedrange?

Yeah I am agree with you .so finally deleting Range (Row and Column) can do this. Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Apr/Fri/2012 12:31 To: excel-macros@googlegroups.com Subject: RE:

RE: $$Excel-Macros$$ Is there a quicker way for vlookup and pivot in Excel when the data is huge, like 10 lakh rows?

Hi, You can do the following to speed up your workbook. 1). Save your file in .xlsb (Binary Format) to reduce size. 2).Remove unnecessary formatting. 3) Use Index Match instead of Vlookup() 4).Set Calculation Manual (Calculate only when required) 5).Use Name Ranges. 6).Sort your data

$$Excel-Macros$$ sumif the based on cell colour

Dear Group members, I want to use sumif function to sum a particular range based on the cell colour. Is it possible. I am enclosing herewith a sample file. Please help.. Thanks Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain Co. Chartered Accountants 3010 Ram Kumar

Re: $$Excel-Macros$$ Need help--macro

Thanks a lot NOORAIN I got it... On Thu, Apr 19, 2012 at 2:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Vijay, Please try below code to change folder path in red color... See attached sheet.. Sub Spilit_in_Workbook() Dim rng As Range Dim i, j, c As Long Dim wb As