Thank you very very much Abhishek Sir And Priti mam.
Once again thank you very much for the solution.
Regards,
Chaya
Regards,
Chaya
On Wed, May 8, 2013 at 12:12 PM, priti verma wrote:
> try this
>
> Sub Highlighting_cell()
>
> Dim rngCell As Range
> Dim rngRange As Range
>
try this
Sub Highlighting_cell()
Dim rngCell As Range
Dim rngRange As Range
Set rngRange = Intersect(Sheet1.Range("a1").CurrentRegion,
Sheet1.Range("a1").CurrentRegion.Offset(1, 1))
For Each rngCell In rngRange
If rngCell.Value > 2 Then
rngCell.Font.Color =
On Wed, May 8, 2013 at 11:33 AM, Chaya wrote:
> Dear Experts,
>
> Please help me in highting number which is greater than 2 by excel vba in
> red colour.
> from B2: F12 range.
>
> Thanks
>
> Regards,
>
> Chaya
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =
Updated as per revised requirement.
On Wed, May 8, 2013 at 12:04 PM, Chaya wrote:
> Dear Experts,
>
> Please help me in highlight number which is greater than 2 by excel vba
> in red colour.
> from B2: F12 range.
>
> Please find the attachment.
>
> Small changes, in Attached file in M2 cell, wh
Here.
On Wed, May 8, 2013 at 11:33 AM, Chaya wrote:
> Dear Experts,
>
> Please help me in highting number which is greater than 2 by excel vba in
> red colour.
> from B2: F12 range.
>
> Thanks
>
> Regards,
>
> Chaya
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
Dear Experts,
Please help me in highlight number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Please find the attachment.
Small changes, in Attached file in M2 cell, whatever the value i will put
the same value greater than its value should highlight it.
Example :
if
Dear Experts,
Please help me in highting number which is greater than 2 by excel vba in
red colour.
from B2: F12 range.
Thanks
Regards,
Chaya
--
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
Hi Sunnny ,
sometime its better to think very simple , we can use Index match as an
array formula but if you have a large data you can have a slow and a heavy
workbook.
so i think of sorting data with if function .
let me know if you have any question on this
regards
Priti verma
On Tue, May 7,
Try this
Sub proc_FindDate()
Set rng = Sheet1.Range("A1:A" & Sheet1.Range("A65000").End(xlUp).Row)
myVal = "N/A"
With rng
Set fndVal = .Find(myVal, LookIn:=xlValues) 'myVal is the date
to be found
If Not fndVal Is Nothing Then
frstAdd = fndVal.Address
Do
I'm trying to push a value from Access to a cell next to a particular date,
ie, if A52 contains 5/7/2013, I want to push a number, say 12 to B52. In
access, I have a link in VBA to Excel and have created a worksheet object.
How do I find the date I want, capture that cell address, then insert
Hi Priti,
Have you checked your solution. it's working fine? (Please sort the data
and check)
Priti please don't put inoperable solution.. its my request
On Tue, May 7, 2013 at 7:28 PM, priti verma wrote:
> Hi Manoj,
> Please see the attachment
> Regards,
> Priti verma
>
>
> On Tue, May
I had used your formula but that was not working fine so i put the value
before your formula
On Tue, May 7, 2013 at 7:17 PM, xlstime wrote:
> i think no need for use value function
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Tue, May 7, 2013 at 6:51 PM, priti verma wrote:
>
>>
i think no need for use value function
.
Enjoy
Team XLS
On Tue, May 7, 2013 at 6:51 PM, priti verma wrote:
> You can use this one also
> =VALUE(SUBSTITUTE(E2,",",""))
>
>
> On Tue, May 7, 2013 at 1:25 PM, danial mansoor wrote:
>
>> dear Experts:
>>
>> Kindly look at my
Noorain bhai,
Need it throgh Vba Coding.
On Tue, May 7, 2013 at 6:39 PM, NOORAIN ANSARI wrote:
> Dear Maksood,
>
> Pls see attachment hope it will help to you.
>
>
> On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
>
>> Hi guys,
>>
>> I have to select two dates, start
You can use this one also
=VALUE(SUBSTITUTE(E2,",",""))
On Tue, May 7, 2013 at 1:25 PM, danial mansoor wrote:
> dear Experts:
>
> Kindly look at my file,there are some numbers kindly convert this into
> numbers it is in text format.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And d
You can also you use formula
like =SUBSTITUTE(E2,",","")
On Tue, May 7, 2013 at 1:30 PM, Ahmed Honest wrote:
> Hi Danial :
>
> Press Ctrl + H and then
>
> in find what box keep comma , and in replace leave it empty and click
> Replace All it shall help...
>
>
>
>
>
>
>
> On Tue, May 7, 2013 a
Hi maksood,
you can use series function with column selection..and in step value put 7
and Stop value put end date
[image: Inline image 1]
On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi guys,
>
> I have to select two dates, start date and end date. e.g. start d
Dear Maksood,
Pls see attachment hope it will help to you.
On Tue, May 7, 2013 at 6:05 PM, maksood alam <786maks...@gmail.com> wrote:
> Hi guys,
>
> I have to select two dates, start date and end date. e.g. start date is
> 31/dec/2012 and end date is 31/jan/2014, then it should start range from
Hi Manoj,
Please find attached solution.. hope it's fulfill your requirements
here i am using Index with match function.. you can also use vlookup with
concatenate but you need to insert one column
.
Enjoy
Team XLS
On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar wrote:
Dear Expert.
please help to solve query.
regd
Manoj
--
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 t
Hi guys,
I have to select two dates, start date and end date. e.g. start date is
31/dec/2012 and end date is 31/jan/2014, then it should start range from
31/dec/2012 and add 7 days and drag it to the end date 31/jan/2014. and it
should be colum wise . See below for more clarification. start and en
You're welcome.
On Tue, May 7, 2013 at 3:07 PM, Chandra Shekar wrote:
> Hi,
>
> Thanks for your reply and it worked.
>
> Regards,
>
> Chandru
>
> On Tue, May 7, 2013 at 1:54 PM, Abhishek Jain wrote:
>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> If Not Intersect(Target, Target.Work
Hi,
Thanks for your reply and it worked.
Regards,
Chandru
On Tue, May 7, 2013 at 1:54 PM, Abhishek Jain wrote:
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Not Intersect(Target, Target.Worksheet.Range("A1:A1000")) Is Nothing
> Then
> MsgBox "A cell from A1 to A1000 is changed."
>
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Target.Worksheet.Range("A1:A1000")) Is Nothing Then
MsgBox "A cell from A1 to A1000 is changed."
End If
End Sub
On Tue, May 7, 2013 at 1:11 PM, Chandra Shekar wrote:
> Hi,
>
> How to check cell ranges using change even
Hi Danial :
Press Ctrl + H and then
in find what box keep comma , and in replace leave it empty and click
Replace All it shall help...
On Tue, May 7, 2013 at 10:55 AM, danial mansoor wrote:
> dear Experts:
>
> Kindly look at my file,there are some numbers kindly convert this into
> numb
dear Experts:
Kindly look at my file,there are some numbers kindly convert this into numbers
it is in text format.
--
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
Hi,
How to check cell ranges using change event. for ex: I need to check
whether user is entering data only in range A1:A1000.
Thanks in advance.
Regards,
Chandra Shekar B
--
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 Faceboo
27 matches
Mail list logo
