Hi Sajid,
Would it be possible for you to share a sample sheet
Regards,
Aindril
On Mon, Jul 5, 2010 at 10:23 AM, SAJID MEMON wrote:
> Hi
>
> Dear I want in excel, when i press enter key cursor should go to particular
> cell example: my cursor is at A1 and after press enter it should go to D15
plz send to all,it will be benificialy for us.
On Mon, Jul 5, 2010 at 10:10 AM, Soni.Rajender wrote:
> Thanks for the ppt.
>
> Regards
> Rajender Soni
>
> On Jul 4, 9:18 am, Ayush wrote:
> > Hi Neil,
> >
> > Thank you for sharing the useful file.
> >
> > Best Regards,
> > Ayush Jain
> > Group Ma
DEAR SIR
YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT.
THANKS A LOT
-KAVI-
On Jul 4, 2:40 pm, Ayush wrote:
> Hi ,
>
> You may also refer to below link to extract numbers from the cell
> :http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-...
>
> To attac
On Jul 4, 2:40 pm, Ayush wrote:
> Hi ,
>
> You may also refer to below link to extract numbers from the cell
> :http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-...
>
> To attach a file you can send an email to excel-
> mac...@googlegroups.com by attaching a file.
>
> Best R
DEAR SIR
YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT.
THANKS A LOT
-KAVI-
On Jul 4, 12:59 pm, Mahesh parab wrote:
> Hi
>
> find attach sheet as per your requirement, find info on below link.
>
> http://www.ozgrid.com/VBA/ExtractNum.htm
>
>
>
> On Sun, Jul 4, 2010 at 10:2
DEAR SIR
YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT.
THANKS A LOT
-KAVI-
On Jul 4, 12:52 pm, ashish koul wrote:
> all numeric
>
> Public Function extractallnumeric(Str)
> Dim i, Numeric1
> Numeric1 = ""
> For i = 1 To Len(Str)
> If (IsNumeric(Mid(Str,
Hi
Dear I want in excel, when i press enter key cursor should go to
particular cell example: my cursor is at A1 and after press enter it should go
to D15-- what is the code? My second query is that when i enter any data
on the form that should store in particular sheet as below cel
Thanks for the ppt.
Regards
Rajender Soni
On Jul 4, 9:18 am, Ayush wrote:
> Hi Neil,
>
> Thank you for sharing the useful file.
>
> Best Regards,
> Ayush Jain
> Group Manager.
>
> On Jul 3, 9:41 pm, neil johnson wrote:
>
>
>
> > Hi Everyone,
>
> > This is ppt of vlookup . I am very lucky , I a
Nadine,
Just type into Sheet1 Cell AQ2 the following:
=VLOOKUP(TEXT(D2;"@");Sheet2!$D:$O;12;0)
regards
2010/7/2 Nadine S
> Attached is a workbook with 2 worksheets: Sheet 1 and Sheet 2
>
> Sheet 1 Col D is how the informatio nis received and it cannot be changed.
>
> Sheet 1 Col AQ is where I
Hi Neil,
As there are multiple items in a range, You need to use FOR EACH statement
to add items of range one by one in listbox.
Attached is the solution for your reference.
I hope it helps. Please let me know if any further assistance is required.
Best Regards,
Ayush Jain
Group Manager.
On
hi,
The default setting for each cell is for them to start locked. So, you first
need to highlight ALL cells in the sheet, right click, choose format, go to
the Protection tab and take the tick out of the Locked box.
Now no cells are locked.
Now you need to select the one cell you want locking.
Hi ,
You may also refer to below link to extract numbers from the cell :
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
To attach a file you can send an email to excel-
mac...@googlegroups.com by attaching a file.
Best Regards,
Ayush Ja
Hi Roop,
Follow the below steps to protect the cells :-
1) Select the cells that need protection.
2) Right click > Format Cells.
3) Go to Protection Tab
4) Select LOCKED CheckBox. (Locked check box restricts editing of cell)
5) Click OK
6) Go to Review tab (in Excel 2007)
7) Click on "Protec
Dear all
I want to know how i can protect a single cell in my work sheet so
that nobody (else me ) can change that cell's data.
thanks in advance
Roop
--
--
Some important links for excel users:
1. Follow us on TWI
Hi
find attach sheet as per your requirement, find info on below link.
http://www.ozgrid.com/VBA/ExtractNum.htm
On Sun, Jul 4, 2010 at 10:25 AM, memonkavi wrote:
> DEAR SIR
>
> PLS ME
>
>
> I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS
> WITH ONE FUNCTION OR TWO
>
>
> REGRADS
> KAVI
Hi Everyone
I make user form , and i reterive cell range through refedit contorl .
when i select the range in refedit control and it show single range value in
listbox
MY *problem is that when i select more range it show error in list box.* *Can
you sort out that prolblem as soon as possible.* I n
all numeric
Public Function extractallnumeric(Str)
Dim i, Numeric1
Numeric1 = ""
For i = 1 To Len(Str)
If (IsNumeric(Mid(Str, i, 1))) Then
Numeric1 = Numeric1 & Mid(Str, i, 1)
End If
Next i
extractallnumeric = Numeric1
End Function
all text
Publ
17 matches
Mail list logo
