Besole,
I get a type mismatch error on ActiveCell.Offset(r, 1) = v.
On Monday, December 16, 2013 8:36:10 PM UTC-5, Basole wrote:
> Hi Bill, try this:
>
> Sub CLEARNUMBERS001()
> s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7",
> "8", "9")
> For Each r In Selecti
Yes. It is working fine.
--
*Rajesh Kumar Agarwal*
*9811063001*
--
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 t
Hi Bill, try this:
Sub CLEARNUMBERS001()
s = Array("+", "-", ".5", "-.5", "0", "1", "2", "3", "4", "5", "6", "7",
"8", "9")
For Each r In Selection
v = r.Value
ActiveCell.Offset(r, 1) = v
For i = 0 To 13
v = Replace(v, s(i), " ")
Next
r.Value = v
Next
End Sub
regards,
Basole
Em segunda-feira,
Hi,
The macro below currently finds and removes selected characters that it
find. It works great. No issues.
What I would like is this to be modified so that if it finds a character
within the array - it will move the character in question to the adjacent
cell to the right, THEN it will cle
Sorry but its not working plz help
On Dec 16, 2013 7:51 PM, "Kuldeep Singh" wrote:
> http://remove-vba-password.software.informer.com/
>
>
> On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep Singh wrote:
>
>> Pfb.
>>
>>
>> http://stackoverflow.com/questions/11649064/excel-spreadsheet-password-cracking-usi
Sorry but its not working
On Dec 17, 2013 1:39 AM, "nitin kumar" wrote:
> Sorry but its not working plz help
> On Dec 16, 2013 7:51 PM, "Kuldeep Singh" wrote:
>
>> http://remove-vba-password.software.informer.com/
>>
>>
>> On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep Singh
>> wrote:
>>
>>> Pfb.
>>>
Hello Priti,
Thanks for effort, and can you please explain the same with SUMIFS
function.?
On 16 December 2013 21:01, priti verma wrote:
> Hi Satiqjaffar ali,
>
> Please try this With Control + Shift + enter
> =SUM(IFERROR(VALUE(IF(G16&F17=$E$6:$E$12&$F$6:$F$12,$G$6:$G$12,"")),""))
>
>
>
> On
Hi Satiqjaffar ali,
Please try this With Control + Shift + enter
=SUM(IFERROR(VALUE(IF(G16&F17=$E$6:$E$12&$F$6:$F$12,$G$6:$G$12,"")),""))
On Mon, Dec 16, 2013 at 9:46 AM, Satiqjaffar ali
wrote:
> Hello experts,
>
> Can you please assist me to sum numbers only in cell. Please find
> attachment
Hello experts,
Can you please assist me to sum numbers only in cell. Please find
attachment and assist. Thanks in advance.
--
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/dis
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 LenSLNo As Integer
> Dim NewS
Dear sir,
apart from this is there any alternative solution i mean any macro of
this. please suggest
thanks
On Wednesday, 4 December 2013 09:40:53 UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Renuka,
>
>
>
> Please try “ASAP utilities” its free ADDIN for 90 days..
>
>
>
> Regards,
>
> *Am
http://remove-vba-password.software.informer.com/
On Mon, Dec 16, 2013 at 7:49 PM, Kuldeep Singh wrote:
> Pfb.
>
>
> http://stackoverflow.com/questions/11649064/excel-spreadsheet-password-cracking-using-vba
>
>
> ---
Pfb.
http://stackoverflow.com/questions/11649064/excel-spreadsheet-password-cracking-using-vba
-
Sub
hello dear,
i'm lost my excel file password & i cant opne file so plz help
& string DPB is not found in hex editor
nitin kumar
On Saturday, February 20, 2010 10:08:47 AM UTC+5:30, cma.ankur wrote:
>
> plz send ur file
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone
Hi all,
I have a huge PowerPoint presentation, most slides with charts. I need to
change the text within the charts - usually the text repeats itself in all
charts. Instead of manually, opening the chart data and pasting the new
text, I wrote the following syntax. All components work, ex
May be you r looking for this. =IF(AND(A90),A9,B8)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: Monday, December 16, 2013 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ formula query
--
Rajesh Kumar
--
*Rajesh Kumar Agarwal*
*9811063001*
--
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. Poor thread titles,
Thanks it is working
On Dec 16, 2013 1:45 AM, "ashish koul" wrote:
> try this
>
>
>
> http://social.msdn.microsoft.com/Forums/sharepoint/en-US/d04fd6b2-6db4-47f2-97a3-3bb364eef80a/upload-an-excel-document-from-an-open-workbook-into-a-sharepoint-document-library?forum=sharepointdevelopmentlegacy
>
18 matches
Mail list logo
