SImple and good suggestion.
On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote:
PFA,
On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow
lucky...@gmail.comjavascript:
wrote:
Hi Team,
I need to extract only the text from the alphanumeric string, can you
please
If you know which cells to copy, use this:
Sheets(Sheet1).Select
Range(A2:B20).Select
Selection.Copy
Sheets(Sheet2).Select
Range(A2).Select
ActiveSheet.Paste
On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote:
I have a database and want to populate data into cells
Error is shown because you cannot use the value of a range in IF statement.
You can only use the value of each cell in that range.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
This is very useful.
http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.htmlhttp://support.microsoft.com/kb/213360
Thanks for this Link.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Welcome. Glad you got your problem solved in this forum.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Try this :
[code]
Private Sub cmdCopyTextFileToAnotherTextFile_Click()
FileCopy D:\data\sample1.txt, D:\data\sample2.txt
End Sub
[/code]
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
In an excel file,
Change Sheet1 Name as Report and type these:
Sr. Center Name Course Date of Enrol Code
1 Alma Computer Training Institute Suraj basic computer Course 31/12/13
2 Center3 Name1 Course 5 1/1/2014
3 Center5 Name2 Course 3 1/4/2014
4 Center2 Name3 Course 4 1/6/2014
5 Center4 Name4
+5:30, renuka chari wrote:
Thank you sir,
i will check this once and tell you
thanks once again
On Thursday, 12 December 2013 22:24:33 UTC+5:30, pmyk wrote:
Add these codes:
[code]
Private Sub UserForm_Click()
Dim AlphaInSlNo As String
Dim NumInSlNo As String
Dim
Try this:
[code]
Private Sub CommandButton1_Click()
Dim FilePath As String
FilePath = D:\VBTrials\VBToThisText.txt 'If it is there it will be opened
'if it is not there it will be created
Open FilePath For Output As #1 'Overwrite in text file
'Open FilePath For Append As #1 'append will add