Hi,
I getting error in this line below from my code
"If Rng1.Value >= 0 And Rng2.Value <= 99 Then"
Basically I want to calculate formula only if values are greater than 0 and
less than 09.
Any help would be appriciated.
Thanks,
Vik
'mycal() is function created by me to calucul
http://www.excelfox.com/forum/f22/get-displayed-cell-color-whether-from-conditional-formatting-or-not-338/
On Thu, Mar 20, 2014 at 9:33 PM, Divaker Pandey wrote:
> what is this dear?
>
> Divaker
>
>
> On Thu, Mar 20, 2014 at 9:18 PM, mrExcel4u wrote:
>
>> Try thishope it will help you...
>
what is this dear?
Divaker
On Thu, Mar 20, 2014 at 9:18 PM, mrExcel4u wrote:
> Try thishope it will help you...
>
> Sub test()
> Application.DisplayAlerts = False
> Application.ScreenUpdating = False
> Dim rng As Range
> Dim cell As Range
>
> Set rng = Application.InputBox("Select a range"
Try thishope it will help you...
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Dim rng As Range
Dim cell As Range
Set rng = Application.InputBox("Select a range", Type:=8)
j = 1
For Each cell In rng
If cell.DisplayFormat.Interior.Color <> 16777215 Then
rcoun
Hi Dear
Please find attachment file.
On Thursday, 20 March 2014 6:12 PM, Vabs wrote:
Hi
What exactly you are looking for in VBA.
Thx
On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote:
Hi Expert,
>
>can any one please share code to retrieve already applied conditional
>formattin
Do you want this or something else?
Sub fc()
Dim cf As FormatCondition
For Each cf In Sheet13.Range("a1").FormatConditions
Debug.Print cf.Formula1
Debug.Print cf.Interior.Color
Debug.Print cf.Font.Color
Debug.Print cf.NumberFormat
Debug.Print cf.AppliesTo.Address
Debug.Pri
Hi
What exactly you are looking for in VBA.
Thx
On Thu, Mar 20, 2014 at 2:04 PM, Divaker Pandey wrote:
> Hi Expert,
>
> can any one please share code to retrieve already applied conditional
> formatting on a cell or range of excel workbook through vba.
>
>
> Thank & Regards,
>
> Divaker
>
> -
use below code
Sub sortCellsValue()
Dim tempStr As String, resultSet As String
Dim tempstrArr() As String
Dim i As Integer
For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
tempstrArr = Split(cl.Value, ",")
tempstrArr = removeDuplicate(tempstrArr)
For i = 0 To UBound(tempst
Dear Divaker,
Works like a charm! Many thanks :)
On Thu, Mar 20, 2014 at 4:30 PM, Divaker Pandey wrote:
> use below code
>
> Sub createSheet()
> Dim cpyRng As String, EmpCode As String, EmpDtl As String
> Dim i As Integer
> Dim totRow As Integer, RecStartRow As Integer, RecEndRow As Integer
>
use below code
Sub createSheet()
Dim cpyRng As String, EmpCode As String, EmpDtl As String
Dim i As Integer
Dim totRow As Integer, RecStartRow As Integer, RecEndRow As Integer
Dim cpyFlag As Boolean
totRow = 190
For i = 8 To totRow
If InStr(ThisWorkbook.Sheets("Sheet1").Cells(i, 1).Value, "** Cod
Hi Dipanke,
One more query i have, please do me favor
I have lots of cells which contains duplicate comma desperated values like
given below
Audi, BMW, Audi
BMW, BMW, Toyota
Honda, Toyota, BMW, Honda
After cleaning it should be look like below:
Audi, BMW
BMW, Toyota
BMW, Honda, Toyota
could
Thanx a lot Divaker!!
its working the way i need
Regards,
Deepak Rawat
On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote:
> use this macro
>
>
> Sub sortCellsValue()
> Dim tempStr As String, resultSet As String
> Dim tempStrArr() As String
> Dim i As Integer
> For Each cl In ThisWorkboo
use this macro
Sub sortCellsValue()
Dim tempStr As String, resultSet As String
Dim tempStrArr() As String
Dim i As Integer
For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271")
tempStrArr = Split(cl.Value, ",")
For i = 0 To UBound(tempStrArr)
For j = i + 1 To UBound(tempStrA
yes but its very time consuming to do mannually sort...
On Thu, Mar 20, 2014 at 2:26 PM, VJ IR wrote:
> Have u tried using text to columns??
>
> Its a simple way to do so.
>
> Regards,
> Vijay Iyer
> On 20 Mar 2014 14:23, "Deepak Rawat" wrote:
>
>> Dear All,
>>
>> I have attached a sheet with
Have u tried using text to columns??
Its a simple way to do so.
Regards,
Vijay Iyer
On 20 Mar 2014 14:23, "Deepak Rawat" wrote:
> Dear All,
>
> I have attached a sheet with rawa data & final data.
>
> I need a macro to sort coma separated data in each cell, like example is
> given below:
>
> N
Dear All,
I have attached a sheet with rawa data & final data.
I need a macro to sort coma separated data in each cell, like example is
given below:
NDTV, BBC, Aaj Tak, Facebook we need to change it as below
*Aaj Tak, BBC, Facebook, NDTV*
i have lots of data to sort, but not getting any solut
you can get max date by the pivot table.
Regards,
Divaker
On Mon, Mar 17, 2014 at 5:47 PM, Imran khan wrote:
> Hi Friends,
>
> I am stuck in working file where i need your help. I have attached file
> for formula.
>
> Thanks & Regards,
>
> *Imran Khan*
>
> *Lead Planner - OR/CSU*
>
> Ras Al-K
Dear Experts,
Please solve the query if possible.
On Wed, Mar 19, 2014 at 2:16 PM, Rakesh Kumar Sharma wrote:
> Dear Varun,
>
> Pls find the attached format.
>
> Same file will be shared with team also. thwy will update location wise on
> sheets
>
>
> On Wed, Mar 19, 2014 at 2:08 PM, Varun Ma
Hi Expert,
can any one please share code to retrieve already applied conditional
formatting on a cell or range of excel workbook through vba.
Thank & Regards,
Divaker
--
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 pag
19 matches
Mail list logo
