Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate the nos and text.
Thanks.
--
--
Some important links for excel users:
1. Follow us on
Can someone help with the following: In one workbook named (Quote) I
would like to copy the contents of Columns A and B to another workbook
named (Anodize). Where the copied contents from (Quote) would be
placed on the next available blank row in Sheet1 Columns A and B. I
know how to place a
Thnaks Ashish.
It is very useful but i am not getting desired output when i copy VBA code
to my actual workbook.Please suggest Where i have to make change.
Regards,
C.G.Kumar
On Mon, Apr 18, 2011 at 6:18 PM, ashish koul koul.ash...@gmail.com wrote:
try this see if it helps
On Mon, Apr
No file found.
On Mon, Apr 18, 2011 at 7:31 PM, Daniel dcolarde...@free.fr wrote:
Hi,
Please, attach file ;-)
Daniel
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* C.G.Kumar
*Envoyé :* lundi 18 avril 2011 10:15
*À :*
Dear Sonu,
Pls attach the solution file.
Pls let me know was it helpful or any problem.
Warm Regards
Bhushan Sabbani
+91 98208 26012
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
paste the macro in worksheet change event . if your search criteria is in
sheet 1 the paste the macro in Worksheet_Change even tof sheet 1
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 3 And Target.Column = 5 Then
ActiveSheet.Rows(6:65356).Clear
Sheets(database).Activate
see if it helps
On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga karankan...@gmail.com wrote:
Hi,
Can any1 pls let me know how do i separate the text and nos in a
given sentence. PFA the sheet where i need to separate the nos and text.
Thanks.
--
add this macro
Private Sub Full_ScreenClose()
' Set Microsoft Excel to Full Screen Display.
Application.DisplayFullScreen = False
End Sub
2011/4/15 Rajesh K R rajeshkainikk...@gmail.com
Hi Experts,
I gave the following code to get the full screen view, if it is only
Please attach file
to better understand !!
2011/4/19 C.G.Kumar kumar.bemlmum...@gmail.com
No file found.
On Mon, Apr 18, 2011 at 7:31 PM, Daniel dcolarde...@free.fr wrote:
Hi,
Please, attach file ;-)
Daniel
*De :* excel-macros@googlegroups.com [mailto:
if you should also indicate if he returns to normal or keep
the FullScreen
2011/4/15 Rajesh K R rajeshkainikk...@gmail.com
Hi Experts,
I gave the following code to get the full screen view, if it is only
applicable to that particular workbook how can i change it.
Private Sub
assuming that the both workbooks are openned
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks(Anodize.xls).Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
correction on the last command.
Sub CanSomeOneHelp()
Dim RgDest As Range
With Workbooks(Anodize.xls).Sheets(1)
.Unprotect
Set RgDest = .Cells(1).CurrentRegion
End With
Set RgDest = RgDest.Cells(RgDest.Rows.Count + 1, 1)
try to use this UDF and see if it helps..
Function GetNumbers(S As String, Index As Integer)
'
' siti Vi / jakarta, 30-08-2009
'
Dim ArrN(), i%, tmp$, n%, t$, t2$
S = Trim(S) |
For i% = 1 To Len(S) - 1
t$ =
I would like to add a checkbox in column A for an Excel spreadsheet.
When the checkbox is checked, you can type in columns B, C and D. If
it is unchecked, the cells are locked.
Ideally, I would like columns B, C and D to be grey if they are
unchecked.
How would I go about doing this?
--
Hi,
How to update the particular row in an excel when some data is
modified in another excel.
Example:
The book1 contains the master file and book2 is the sub file. When the
user updates/modified some records in Book2, it should refelect in
book1 for that particular record. Is it possible to do
unlock all cells in column A
instanciate a checkbox in cell A1 (CheckBox1)
create a conditional formatting for B1:C1
put the thos vba code to Sheet1 Module
Private Sub CheckBox1_Click()
Me.Unprotect
If CheckBox1 = False Then
Range(B1:C1).Locked = True
Else
16 matches
Mail list logo