$$Excel-Macros$$ Querry !

2009-05-04 Thread shafiq online
Can anyone tell me how can I hide row and column heading?... I mean calumn names for example a.b.c.d in default and row names 1 2 3 etc. Regards _ Show them the way! Add maps and directions to your party invites. http://ww

$$Excel-Macros$$ Re: Random Selection

2009-05-04 Thread Fabio Lemos
The formula was wrong, see this new file. 2009/5/4 Fabio Lemos > you could create a variable range name and use it in your formula... > > 2009/5/4 Satti Charvak > > Prepare en excel sheet and send it back...your usage of the formula is not >> clear. >> >> On Mon, May 4, 2009 at 7:05 AM, Blank

$$Excel-Macros$$ Re: Random Selection

2009-05-04 Thread Fabio Lemos
you could create a variable range name and use it in your formula... 2009/5/4 Satti Charvak > Prepare en excel sheet and send it back...your usage of the formula is not > clear. > > On Mon, May 4, 2009 at 7:05 AM, Blank wrote: > >> >> I am trying to get a random selection of a cell containing t

$$Excel-Macros$$ Macro Help!

2009-05-04 Thread bcap
Hi, Is there a way to create a Macro that will allow an image to automatically popluar in cell A1? This would also need to work when a new worksheet is created. Any thoughts and/or samples would greatly be appreciated. --~--~-~--~~~---~--~~

$$Excel-Macros$$ Where does XL store the clipboard ? or where does Windows store clipboard ?

2009-05-04 Thread Subu
Dear Members Where does XL store the clipboard ? or where does Windows store clipboard ? Vital Stats : - Using a Win XP Machine - using medium sized (100 rows, 20 column) sp sheets on MS Excel 2003 (MS Office 2003) My Machine is networked so that my documents is backed up on a server automatical

$$Excel-Macros$$ Re: Random Selection

2009-05-04 Thread Michael Fowler
I have a attached a sample file that includes cells (col. A) that I want to get a random cell from. The blank cell above each of the two ranges is what I want to use to extract a random cell from the cell range below it. The range is always different and I am trying to do something like what I have

$$Excel-Macros$$ Where does XL store the clipboard ? or where does Windows store clipboard ?

2009-05-04 Thread Subu
Dear Members Where does XL store the clipboard ? or where does Windows store clipboard ? Vital Stats : - Using a Win XP Machine - using medium sized (100 rows, 20 column) sp sheets on MS Excel 2003 (MS Office 2003) My Machine is networked so that my documents is backed up on a server automatical

$$Excel-Macros$$ Re: single password for excel

2009-05-04 Thread Prashanth Banneni
Hi all, Can any one give me the password breaker tool. Thanks in advance Regards, Prashanth On Sat, May 2, 2009 at 3:06 PM, girish gv wrote: > post the file i will break the password > > On 12/19/08, jasm...@1908 wrote: >> >> HI there,…. >> >> >> >> Send me the file and I will break the pas

$$Excel-Macros$$ Re: Open XL - A Powerful Excel Addin

2009-05-04 Thread satish
Dear Ashish Am still waiting for your response to successfully install OPEN XL Add- in. Please guide me... Regards Satish On Apr 28, 6:02 pm, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Satish, > > are you sure? You are using the correct version. > My solution may sound unappropriate but

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread msakibkhan
Hi Jesper. there are some confusions, anywayz I can help you if you will attach a required sample. So I will ammend it with solution. OK On May 4, 12:22 pm, Jesper wrote: > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread msakibkhan
Hi Jesper. there are some confusions, anywayz I can help you if you will attach a required sample. So I will ammend it with solution. OK On May 4, 12:22 pm, Jesper wrote: > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread Harmeet Singh
Range("a1").End(xlDown).Offset(1, 0).PasteSpecial On Mon, May 4, 2009 at 12:52 PM, Jesper wrote: > > Hi all > > I have a little problem with this VBA thing. I need to make a > macro that can find the first empty row and paste the content of the > clipboard in that row from col A > > col H al

$$Excel-Macros$$ Re: Find the first empty row

2009-05-04 Thread Alokeshwar Tiwary
Sub SelectFirstEmptyRow() Dim r As Long r = Application.WorksheetFunction.CountA(Range("A:A")) Cells(r, 1).Select End Sub _ "There are known knowns. These are things we know that we know. There are kn

$$Excel-Macros$$ Find the first empty row

2009-05-04 Thread Jesper
Hi all I have a little problem with this VBA thing. I need to make a macro that can find the first empty row and paste the content of the clipboard in that row from col A col H allways have data so that one would be a good col to use to find the first empty cell If more info is needed just

$$Excel-Macros$$ Re: Random Selection

2009-05-04 Thread Satti Charvak
Prepare en excel sheet and send it back...your usage of the formula is not clear. On Mon, May 4, 2009 at 7:05 AM, Blank wrote: > > I am trying to get a random selection of a cell containing text, > basically: > > IF there is an empty cell in a column, get a random cell of data from > the range b