Hi
Use this code:
Sub Macro1()
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
Range("F4:F16").ClearContents
ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, Criteria1:=RGB(255, _
0, 0), Operator:=xlFilterCellColor
a = Range("A" & Rows.Count).End(xlUp).Row
Set Rng =
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Nov 4, 2014 at 11:56 AM, Ashish Kumar
wrote:
> Hi Vaibhav Bhai,
>
> It's perfect.
>
>
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,
Hi Vaibhav Bhai,
It's perfect.
Regards
Ashish
--
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 threa
myxlguru,
Add new module in this macro with follo. code.
Call this macro whenever there is unsuccessful event.
Once macro is ready create add-in of macro file & install it.
So whenever is excel is loaded it will disable addins if unsucessfull
login..
code:
Sub Disable_Addin()
Dim ThisComp
thanks for replying
i named this mail id as myxlguru
bcoz whatever i posted question in this group i got exact & correct answer
who send solution to me i called him as guru (master)
vaibhav sir, ashish sir, paul sir etc all are masters master
thanks
On Mon, Nov 3, 2014 at 8:08 PM, joseph camill
--
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, like Please Help,
Urgent, Need Help, F
Trying to filter a few numbers from a larger group of numbers in one cell,
copy them, then paste them in another cell. Error comes up as "Runtime
error '1004': Paste special Method of Range class fail". When I go to
"debug", it shows this:
[image: copy to clipboard]
Sub Macro1()
'
' Macro1 Ma
In the attached excel file (version 2007), the first sheet is "quiz" and
second sheet is "sheet1". It has a question/answer sheet (sheet1) that is
designed in such a way that the first letter of the question is prefixed
with the answer. For example here is a sample data in the range A1:A20
whic
Hi,
I am not sure who this is "myxlg...@gmail.com". Please use a different mail
to solve your queries, as it may confuse me to look for an appropriate
answer and ask question to the experts.
On Sun, Nov 2, 2014 at 7:05 PM, my excel wrote:
> Pramod is it possible to use this login form to exce
Hi All.
User id 123456
Password: 321
REgards
Pramod
On Mon, Nov 3, 2014 at 6:48 PM, Ashish Kumar wrote:
> Hi,
>
> Try this UserName & password.
>
> UserID - 123456
> Password - secret
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =T
Hi,
Try this UserName & password.
UserID - 123456
Password - secret
Regards
Ashish
--
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 concis
Guru Vaibhav Sir,
is it possible to use this login form to excel add-in file
using this authorized user can use (run) add-ins macro
add-in name => ctools
macro names=> get SlNo, Top10, Reports etc
Sir, pls send code for add in if login success than only add-in macros
enable else disable
thanks
How do you want to do this?
I simply highlighted the ū and hit ctrl-c
then selected all cells and hit ctrl-h (to find/replace)
in the find box, i hit ctrl-v to paste the ū
in the replace with box, i inserted u
and then hit ReplaceAll.
it worked just fine.
Paul
-
Hi Pramod,
None are working.
On Mon, Nov 3, 2014 at 7:18 AM, Pramod Singh wrote:
> User id is 123456
> Password may be 321 or 123 or the
>
> Try in three password. .
>
> Regards
> Pramod
>
> Pramod
> On 3 Nov 2014 02:02, "joseph camill" wrote:
>
>> Hi,
>>
>> I do not need an add-in, need to wo
14 matches
Mail list logo