Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread ravinder negi
PFA,and try same in your file. From: Excel_Lover To: excel-macros@googlegroups.com Sent: Sunday, September 1, 2013 8:15 PM Subject: $$Excel-Macros$$ Keep Excel in Full Screen Dear All, I am using the below code in the Workbook_Open event to display the exc

Re: $$Excel-Macros$$ Getting Array out of Bound Error

2013-09-01 Thread अनिल नारायण गवली
Dear Saggi, Pl share the file with us. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Mon, Sep 2, 2013 at 11:04 AM, shyam.utha...@gmail.com wrote: > > > Sent from my HTC > > > - Reply message - > From: "saggi" > To

Re: $$Excel-Macros$$ Getting Array out of Bound Error

2013-09-01 Thread shyam.utha...@gmail.com
Sent from my HTC - Reply message - From: "saggi" To: Subject: $$Excel-Macros$$ Getting Array out of Bound Error Date: Mon, Sep 2, 2013 10:34 am Dear All, Don't know what happened all of sudden, below given code giving Arrgy Out of bound error. Worked fine till yesterday. Below g

$$Excel-Macros$$ Getting Array out of Bound Error

2013-09-01 Thread saggi
Dear All, Don't know what happened all of sudden, below given code giving Arrgy Out of bound error. Worked fine till yesterday. Below given code i am using for download attachment from outlook to my specific folder. debug n highlighted in yellow color where i am getting above mention error

Re: $$Excel-Macros$$ Loop to check if cell is blank, if so copy the cell above

2013-09-01 Thread Sam Mathai Chacko
I'm sure you've figured out the 'with' part. The formular1c1 just passes the formula mentioned there to all blank cells. The trick is in using it as an r1c1 formula. If you look closer, all it is passing is the equivalent of one row above, denoted by the minus one in the square brackets and the sam

Re: $$Excel-Macros$$ Loop to check if cell is blank, if so copy the cell above

2013-09-01 Thread Clark Feusier
Ah perfect!! Thanks so much Sam. I had hacked together a recorded macro that used function f5 goto special blanks and then inputing the start of the range and control+copying. Your way is much better. If you end up having a second, could you explain what this is doing and how? If not, I total

Re: $$Excel-Macros$$ Loop to check if cell is blank, if so copy the cell above

2013-09-01 Thread Sam Mathai Chacko
Try this Clark With Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row).SpecialCells(xlCellTypeBlanks) .FormulaR1C1 = "=R[-1]C" .Value2 = .Value2 End With On Sun, Sep 1, 2013 at 11:55 PM, Clark Feusier < clark.feus...@creativetrust.com> wrote: > I am very new to excel

$$Excel-Macros$$ Loop to check if cell is blank, if so copy the cell above

2013-09-01 Thread Clark Feusier
I am very new to excel VBA macros and I am trying to figure out how to go through all of the cells in a single column starting from the top and and checking each cell to see if it's blank/empty. If blank, I would like the macro to paste the cell contents from directly above. If the cell isn't e

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-09-01 Thread Clark Feusier
Hey All, Clark Feusier here. I am from California and live in Nashville, Tennessee. I am a product manager and get to play around online most of my day. I am pretty trying to streamline some of my work by learning to utilize macros. Thanks! Clark On Friday, June 8, 2012 2:21:59 PM UTC-5, Ayus

Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread Excel_Lover
Its working fine, Thanks you very much. On Sun, Sep 1, 2013 at 6:18 PM, ashish koul wrote: > Private Sub Workbook_Activate() > Application.DisplayFullScreen = True > Application.OnKey "{ESC}", "" > End Sub > > Private Sub Workbook_BeforeClose(Cancel As Boolean) > Application.DisplayFullScreen

Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread ashish koul
Private Sub Workbook_Activate() Application.DisplayFullScreen = True Application.OnKey "{ESC}", "" End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFullScreen = False Application.OnKey "{ESC}" End Sub Private Sub Workbook_Deactivate() Application.DisplayFullScreen =

Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread Excel_Lover
Dear Mr.Bé Trần Văn, Thanks for your attention, But I need the excel to remain in full screen not 'User Form' On Sun, Sep 1, 2013 at 6:09 PM, Bé Trần Văn wrote: > You to use the codes in ThisWorkbook. > > Private Sub Workbook_Open() > ActiveWorkbook.Sheets("Nhap lieu").Activate > With User

Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread Bé Trần Văn
You to use the codes in ThisWorkbook. Private Sub Workbook_Open() ActiveWorkbook.Sheets("Nhap lieu").Activate With UserForm1 UserForm1.Show UserForm1.Top = 0 UserForm1.Left = 0 End With End Sub Note: ("Nhap lieu") the sheet name to the UserForm 2013/9/1 Excel_Lover > Dear All

$$Excel-Macros$$ Skipping Columns when importing XML file to sheet

2013-09-01 Thread Nic Nat
Hi everybody For example, for a given record, Telefone column allocated values from your neighbor Date of Contact column when there is no Telefone value to fill in. I think that this occurs because for a given record a value for the Telefone column was not filled by the user. So, a value of dat

$$Excel-Macros$$ Keep Excel in Full Screen

2013-09-01 Thread Excel_Lover
Dear All, I am using the below code in the Workbook_Open event to display the excel in full screen. Application.DisplayFullScreen = True But, I need the excel to remain in full screen even if the user press 'Esc' button. Appreciate your suggestions. Best Regards Excel_Lover -- Are you =EXP(E

Re: $$Excel-Macros$$ Fwd: Microsoft Excel Re: vlook up button for single click

2013-09-01 Thread jmothilal
attachment missing On Sat, Aug 31, 2013 at 10:46 PM, Pravin Gunjal wrote: > > > -- Forwarded message -- > From: veeru > Date: Fri, Aug 30, 2013 at 8:15 PM > Subject: Microsoft Excel Re: vlook up button for single click > To: microsoft-office-2...@googlegroups.com > > > no one s