Daniel,
It working but i want draft format should be in plain text or HTML. now it is
in Rich text.
Please can u help on this.
Regards,
Shrinivas
Query Unit
Securities Services
Global Transaction Services - India.
Ph: +91-80-41446339
E-Mail: shrinivas.chidur...@citi.com
-Original Message-
Hi Friends,
Please tell me about repalcement of (*)
Example
*Validation_Type* Manual*** Check** Manual***Check** Manual** Check*
*Calling* Manual ***Check **Manual**Check**
--~--~-~--~~~---~--~~
-
I tried your suggestion but the VBA still replaces all occurrences of
"1234" across the entire workbook and not just the active sheet.
- Andrew
On Jul 5, 2009, at 9:54 PM, Norman May wrote:
> Try this:
>
> ActiveSheet.Cells.Replace What:="1234", Replacement:="",
> LookAt:=xlWhole, _
> Sear
Try this:
ActiveSheet.Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
Norman
On Sun, Jul 5, 2009 at 9:14 PM, Ritland wrote:
>
> I know this must be a simple quesiton but I'm stumped. I wanted to
I know this must be a simple quesiton but I'm stumped. I wanted to do
the following search within the active sheet only NOT the entire
workbook.
'
Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
_
Repla
I know this must be a simple quesiton but I'm stumped. I wanted to do
the following search within the active sheet only NOT the entire
workbook.
'
Cells.Replace What:="1234", Replacement:="", LookAt:=xlWhole, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False,
_
Re
Could you post a sample file ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Balachander S
Envoyé : dimanche 5 juillet 2009 18:11
À : excel-macros@googlegroups.com
Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: V look up error 1004
Attn
Hi Lynn,
Please go thru the link below. This will help solve the problem.
http://www.fontstuff.com/vba/vbatut07.htm
Regards,
Andy
On Sat, Jul 4, 2009 at 7:25 PM, Lynn wrote:
>
> this is not what I wanted. I do not want the calendar to be shown on
> the excel sheet.
> It should only pop-up whe
Hi,
Assuming accno is a named range, try one of the following:
WorksheetFunction.VLookup(("accno"), Range("q4:w570"), 5, False)
or
WorksheetFunction.VLookup(Range(accno), Range("q4:w570"), 5, False)
or
WorksheetFunction.VLookup(Range("accno"), Range("q4:w570"), 5, False)
Regards - Dave.
Date: S
Attn Daniel
Range q 4 w 570 contains digits
Changed the code to DBL
same error 1004 :"unable to get the Vlook property of the worksheet function
class"
Same error
Any other suggestions
S Baloo
On Sun, Jul 5, 2009 at 9:32 PM, Daniel wrote:
> « 'accno = ComboBox3.Value »
>
>
>
> Comboboxes r
« 'accno = ComboBox3.Value »
Comboboxes return string value ; if « Range("q4:w570") » contains digits,
you may have this error.
Change to :
accno = cdbl(ComboBox3.Value)
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Balachander S
E
I don't understand what you are trying to tell me. I don't the command
"Date ?" either.
Could you further explain?
On Jul 4, 10:21 pm, "Daniel" wrote:
> Did you have a look at my workbook. The command "Date ?" is added to the
> cell right click menu when the file is opened. It is removed when t
Can some body in the group tell me why error occurs for V look up function
Private Sub ComboBox3_Change()
'accno = ComboBox3.Value
Workbooks.Open Filename:="h:\credit\Limits of rs 25 lacs and over"
Worksheets("sheet1").Activate
ccode = WorksheetFunction.VLookup((accno), Range("q4:w570"), 5, False
Hi Jessie,
If you attach a sample workbook, we will be able to help you better.
I use this method a lot, but I need to know how your data is laid out.
Regards - Dave.
> Date: Sat, 4 Jul 2009 04:57:42 -0700
> Subject: $$Excel-Macros$$ FIND COMMAND IN EXCEL VBA
> From: jayachitra.dreamzunlimi...@gm
14 matches
Mail list logo
