Hi, let me re-iterate your problem. You are trying to copy data from
excel sheet and put it into a linked excel sheet in the PPT to create
graphs right? This can be done in VBA using OLE objects but
unfortunately we cannot do it in Excel 2007 as this feature has been
taken off. Having said that you
Hey Ashothosh,
Please make use of absolute cell reference.
http://www.techonthenet.com/excel/questions/referencing.php
Regards,
Rajesh Kunder
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule
Hey,
Hold the cursor where you want to insert the rows. And press ctrl +
twice.
Regards,
Rajesh Kunder
On Fri, Jun 26, 2009 at 4:04 PM, Mahesh wrote:
> Hi All,
>
> Need Your help,
>
> I want 2 insert 2 empty rows between 2 rows containing data.
>
> Please suggest
"
If Start Then ch = UCase(ch): Start = False
Case "A" To "Z"
If Start Then Start = False Else ch = LCase(ch)
End Select
Mid(s, i, 1) = ch
Next
cell.Value = s
Next
End Sub
Regards,
Rajesh kunder
ToolPak* box,
and then click *OK*.
3. If necessary, follow the instructions in the setup program.
Regards,
Rajesh Kunder
On Wed, Jun 24, 2009 at 2:49 PM, Dave Bonallack
wrote:
> Hi Dilip,
> When I open your workbook (with XL2000), it functions as you say it should.
> However, when
n Function
'
Dim Temp As String
Temp = ""
For Each Cell In rng
Temp = Temp & Cell.Value & ", "
Next Cell
CommaCon = Mid(Temp, 1, Len(Temp) - 2)
'
End Function
It should work :-)
Regards,
Rajesh Kunder
On Mon, Jun 22, 2009 at 11:41 PM, Adam Lazzarato
wrote:
>
Thanks Ayush and everyone :-)
Regards,
Rajesh Kunder
On Mon, Jun 22, 2009 at 7:49 PM, Ayush wrote:
>
> Hello Everyone,
>
> Please congratulate Rajesh Kunder for winning the Best Excel Tip award
> of Week # 25. This is really great news that people are participating
> in the
Hey Anil,
Please use this formula =ASAPSPELLNUMBER(A1). The function is
already present in ASAP Utilities.
Thanks,
Rajesh Kunder
On Mon, Jun 22, 2009 at 4:00 PM, Anil Kumar Agarwala
wrote:
> Dear Rajesh,
>
> Sorry I was not aware. Could you point out the exact men
Hey Anil Kumar,
This feature is there in ASAP Utilities.
Thanks,
Rajesh Kunder
On Mon, Jun 22, 2009 at 1:00 PM, Anil Kumar Agarwala
wrote:
> Dear Shiv Pratap
>
> There is no built in function in excel to do it. You have to use custom
> made function for th
Hey,
Please send me the file, i'll put the formula and send it to you.
Regards,
Rajesh Kunder
On Sat, Jun 20, 2009 at 2:24 PM, ankur wrote:
>
> Dear Members
>
> i have one problem
> in one sheet there is data as
> party name bill no.
Hi,
Download ASAP Utilities and convert numbers to text and so many other
features.
http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=71&utilities=Numbers
Regards,
Rajesh Kunder
On Sun, Jun 21, 2009 at 6:43 PM, Shiv Pratap wrote:
> Hi Friends,
>
> I have a si
Hi,
Name: Rajesh Kunder
*TIP: Identifying Merged Cells*
**
*Please follow the below mentioned steps to identify all merged cells in
excel at one shot !*
**
**
**
1. *Ctrl+F*. Excel displays the Find tab of the Find and Replace dialog
box.
2. If necessary, click the Options
Hello Ahmet,
Please try this formula,
=IF(MOD((A1-1),12)=0,12,MOD((A1-1),12)) where A1 is the active cell.
Regards,
Rajesh Kunder
On Thu, Jun 18, 2009 at 4:56 PM, Ahmet Yalcin wrote:
> Hello You Helpful People :)
>
> My question today is:
>
> For exampl
* : Please download ASAP Utilities, no need for a macro!
http://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=37&utilities=Sheets
Regards,
Rajesh Kunder
On Thu, Jun 18, 2009 at 3:19 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> *Q.1* I have a 30 sheets in a file. I
This will help you.
http://www.functionx.com/vbaexcel/
Thank You,
Rajesh Kunder
On Thu, Jun 18, 2009 at 11:09 AM, lingesh p wrote:
> Hi all,
>
> Can anyone send me a ppt or an overview abt macros
> i want to learn the basics of macros. is there any one who can help me
Hi,
I am Rajesh Kunder from Bangalore.
*Tip Name : *
We all know how to split a worksheet using keyboard shortcut(ALT+W+S). But
there is one more tricky way of doing it!.
Create a horizontal split by clicking on the little bar shape next to
horizontal scroll-bar near top right corner of the
Hey Mahender,
N() formula is used to hide the text. Its similar to comments in any
other programming languages.
Ex: Lets say i want to find out the area of a rectangle. Then the formula is
a*b.
In cell A1, i write =5*6+N("side1*side2"), the answer you get is 30. But you
cannot see N("side1*si
Hey Mahender,
*N() *formula is used to hide the text. Its similar to *comments *in any
other programming languages.
Ex: Lets say i want to find out the area of a rectangle. Then the formula is
a*b.
In cell A1, i write =5*6+N("side1*side2"), the answer you get is 30. But you
cannot see N("side
18 matches
Mail list logo