Re: $$Excel-Macros$$ Macro Help in Excel 2007?

change Sheets(1) as per your requirement activesheet or Sheets(" name of sheet") On Fri, Apr 15, 2011 at 11:57 PM, Prabhu wrote: > Hi Ashish, > > Thanks, But when i run the macro i had an issue > > 1) It is woking only on the Sheet 1 only not other sheet > > 2) I want to use this code with

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

try this link http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zip&can=2&q On Sat, Apr 16, 2011 at 11:03 AM, OpenExcel.com <26may.1...@gmail.com>wrote: > Hi Bhushan, > > Files section has been removed from google groups. Go to > http://www.openexcel.com and click on downloads. >

$$Excel-Macros$$ Re: Open Excel addin is unavailable

Hi Bhushan, Files section has been removed from google groups. Go to http://www.openexcel.com and click on downloads. Here is the Direct Link to Download: http://openexcel.googlecode.com/files/OPEN_XL.zip Regards Ashish Jain -- -

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

Hello Ashish, My problem is not solve till yet.Awaiting for the reply. The download link of the Open Excel addin is unavailable on http://www.openexcel.com The unavailable link is http://excel-macros.googlegroups.com/web/OpenXLBeta1.0.0.0.zip?gda=7UqvmUcAAABeK1bCvIVb6K29sqTYZWWthiVAWnx9NyJFXKN

Re: $$Excel-Macros$$ inputbox format

The change worked perfect. Thank you so much! On Apr 14, 3:09 am, "STDEV(i)" wrote: > please try this vba code > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) >    If Target.Count = 1 Then >       If Target.Column = 3 Then >          Dim T As Integer >          T = Application.In

Re: $$Excel-Macros$$ Problem in pivot table

plz put up all poor, avg, good, very good in one column then create pivot table On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours layout. But my pivot > is little bit complicated.Why is th

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

Hi Ashish, Thanks, But when i run the macro i had an issue 1) It is woking only on the Sheet 1 only not other sheet 2) I want to use this code with other macro as a Continuation Plz help from which line i have to copy to my exising macro code. Regards, Prabhu -- ---

Re: $$Excel-Macros$$ Re: Problem in pivot table

Hi Saggi, Please send one attachment. Please tell me How to use formula in pivot table in excel 2003? Regards, Alisha On Fri, Apr 15, 2011 at 9:43 AM, saggi wrote: > Count of Divisions PoorAvg GoodV Good > > Total Grand Total > Total A

Re: $$Excel-Macros$$ Problem in pivot table

its because its showing subtotals . hide them thats it . keep the cursor on vgood right click and unselect subtotal ,same for good etc. On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi Ashish, > > I have made the pivot table using the layout as yours

Re: $$Excel-Macros$$ Macro Help

Hi Try Sub Test() Last = Cells(Rows.Count, "A").End(xlUp).Row For i = Last To 1 Step -1 If IsError(Cells(i, "A")) Then Cells(i, "A").EntireRow.Delete End If Next i End Sub On Fri, Apr 15, 2011 at 3:24 PM, Prabhu wrote: > Hi, > > I want to delete particular rows only in my work sheet which cont

Re: $$Excel-Macros$$ Problem in pivot table

Hi Ashish, I have made the pivot table using the layout as yours layout. But my pivot is little bit complicated.Why is that so happening?. Why did you use employee code in data instead of count of poor or count of avg etc.? I am sending you the attachment. Regards, Alisha On Fri, Apr 15, 2011 at

$$Excel-Macros$$ Re: Macro Help again

Hi, see the attached File,, it meets the operational requirement On Fri, Apr 15, 2011 at 10:17 PM, rajan verma wrote: > see if it help > > Rajan > > > On Fri, Apr 15, 2011 at 9:32 PM, ashish koul wrote: > >> >> >> -- Forwarded message -- >> From: David Stevans >> Date: Fri, Apr

$$Excel-Macros$$ Re: Macro Help again

see if it help Rajan On Fri, Apr 15, 2011 at 9:32 PM, ashish koul wrote: > > > -- Forwarded message -- > From: David Stevans > Date: Fri, Apr 15, 2011 at 6:37 PM > Subject: Macro Help again > To: ashish koul > > > Hi, > > How are you I need some more help with the macr you gav

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

Why "at one time"? I don't think you're going to get that... But if you use: Option Explicit Sub Del_Rows()     Dim rCnt, R     Sheets("Data").Select     Range("A1").Select     Application.ScreenUpdating = False     rCnt = ActiveCell.SpecialCells(xlLastCell).Row     For R = rCnt To 1 Step -1

Re: $$Excel-Macros$$ Macro Help in Excel 2007?

try this code assuming you have data in col a to col c and you want to delete all records with #n/a in col C Sub TEST() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False If Sheets(1).FilterMode Then Sheets(1).ShowAllData End If Sheets(1).Range("A1:C" & R

$$Excel-Macros$$ Re: Password protect & unprotect sheets using code

I pulled your answer from URL listed below, second and third post both give different approaches depending on your needs. Below protects and unprotects all sheets, if you just need one sheet there are other options in the following URL. http://www.ozgrid.com/forum/showthread.php?t=20766&page=1 Di

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Please send excel file. On Fri, Apr 15, 2011 at 5:21 PM, Rajesh K R wrote: > Hi Experts, > > I want to password protect my work sheets, but the same time it is > necessary to unprotect it for the running of macro so i have to give a > code to unprotect them. how can I do it. > > Regards > > Rajes

$$Excel-Macros$$ Macro Help in Excel 2007?

Macro Help in Excel 2007? I want to delete particular rows only in my work sheet which contains #N/A in a particular column? Assuming the column containing the #N/A errors is column A, and i need to delete the entire row where '#N/A' if found in column A. Plz help with macro code which should

$$Excel-Macros$$ Macro Help

Hi, I want to delete particular rows only in my work sheet which contains #N/A in a particular column? Assuming the column containing the #N/A errors is column A, and i need to delete the entire row where '#N/A' if found in column A. Plz help with macro code *which should delete enter #N/A at

Re: $$Excel-Macros$$ Password protect & unprotect sheets using code

Sub ABCD() Sheets("MySheet").Unprotect "yourpassword" --- your program accessing to sheets("MySheet") Sheets("MySheet").Protect "yourpassword" End sub On Fri, Apr 15, 2011 at 6:51 PM, Rajesh K R wrote: > Hi Experts, > I want to password protect my work sheets, but the same time it is > necessar

$$Excel-Macros$$ Password protect & unprotect sheets using code

Hi Experts, I want to password protect my work sheets, but the same time it is necessary to unprotect it for the running of macro so i have to give a code to unprotect them. how can I do it. Regards Rajesh kainikkara -- --

$$Excel-Macros$$ Show full screen for a particular workbook only.

Hi Experts, I gave the following code to get the full screen view, if it is only applicable to that particular workbook how can i change it. Private Sub Workbook_Open() Application.DisplayFullScreen = True End Sub Regards Rajesh kainikkara -- --

$$Excel-Macros$$ Re: Ashish Koul : Most Helpful Member - March 2011

Many congratulations Ashish... Keep up the helping spirit. Best of Luck. DILIPandey On Apr 2, 2:24 pm, Ayush Jain wrote: > Hello Everyone, > > Ashish Koul has been selected as 'Most Helpful Member' for the month of > March'11 > He has posted 48 posts in March 2011 and helped many people through

Re: $$Excel-Macros$$ Unable to break the links of worksheet

try this code Sub BreakLinks() 'Author : Ken Puls (www.excelguru.ca) 'Macro Purpose: Break all links in the active workbook Dim vLinks As Variant Dim lLink As Long ' Define variable as an Excel link type. vLinks = ActiveWorkbook.LinkSources(Type:=x

$$Excel-Macros$$ Unable to break the links of worksheet

Hi All, Could you please help me many a times I wanted to break the links of my work sheet but I unable to do this... It also don't show any error but workbook still shows links. Thanks & Regards, Anil Bhange IP - 512320 --

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

by Text to Column you change its format. Short Key is ALT+D+E Select *Delimited -> Click Next -> Click Next -> Select Date Format (DMY) -> Click Finish* On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor wrote: > Dear all, > > Would like to seek your kind assistance/help on the date f

Re: $$Excel-Macros$$ Problem in pivot table

Like this??? On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra < alisha.malhotr...@gmail.com> wrote: > Hi, > > I want to create one pivot table. In this, *I want to calculate the number > of employees in Poor, Avg, good, and very good.* > But it is showing the same no. of employees in each catego

$$Excel-Macros$$ Conditional formating help

Dear all , please find herewith attached file .I want some help about conditional formating. Matter is urgent. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Re: Problem in pivot table

Count of Divisions PoorAvg GoodV Good Total Grand Total Total Avg Avg Total Total GoodGood Total Total Divisi

Re: $$Excel-Macros$$ Re: Open Excel addin is unavailable

http://code.google.com/p/openexcel/downloads/detail?name=OPEN_XL.zip&can=2&q = On Fri, Apr 15, 2011 at 10:26 AM, ashish koul wrote: > try this > > =SUBSTITUTE(B3,".","-")-SUBSTITUTE(A3,".","-") > > On Fri, Apr 15, 2011 at 8:34 AM, Mohd Sanusi Mohd Noor < > sanus...@gmail.com> wrote: > >> Dear