Hi ,
I need to extract a relevant portion from Excel cell.
Attached example file.
Many Regards,
C.G.Kumar
--
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
Hi Zeeshan,
I have used this method myself--it's always worked for me.
Have you tried it this time? If you have trouble, just repost your file and
I will look at it to see what the problem is.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Hi Rossoff,
Thx for the tip, i have tried this before but it did not worked.
not to disappoint you, however the purpose of protection is to hide
Formula's.
regards,
Zeeshan
On Thu, Dec 6, 2012 at 9:33 AM, Asa Rossoff wrote:
> *Hi Zeeshan,*
>
> You can enable outlining on protected sheets by
Hi Prince,
You are absolutely correct, however i am novice when it comes to Macro and
thats reason i think intellectuals like you can help me over. :)
Warm Regards,
Zeeshan
On Thu, Dec 6, 2012 at 8:59 AM, Prince wrote:
> Hi Zeeshan,
>
> I thinnk you need to write a macro that will unprotact y
Congratulations Paul!
I really appreciate your generosity, expertise, and communication skills.
I'm happy to see you honored for your contributions.
You have an EXCELLENT point about the challenges so many here rise above
beyond just the technical. I have great respect for the group as a whol
Hi All,
I have a string with comma separated values (say N values)
(E.g. 233, 127, 139, 38, 560, 72, 56, 67, 45, 232, 28, 242, 344, 234, 034,
072, 342, 34, 5, 34, 34, 6, 782, 342, 34, 234, 2, 423, 45, 23, 21, 56, 03,
08, 56, 22, 94, 22.4, 23.1, 40, 45, 242, 475, 21, 24, 23, 423, 444, 24, 75,
67
Hi Zeeshan,
You can enable outlining on protected sheets by use of some simple VBA code.
There is a protection option available only via VBA called
"UserInterfaceOnly". It's purpose is to allow other VBA code to maipulate
protected sheets freely, but have the sheets otherwise stay fully prote
Hi Maccue,
Can you Please shere your workbook with us.
Regards
Prince
On Thursday, December 6, 2012 2:43:02 AM UTC+5:30, Mccue wrote:
>
> I have this macro that I run everyday.
>
> But it is a password protected excel sheet so Macro is asking me to put in
> the password during macro is runnin
Hi Dhaval,
for low date please "max" with Min and Press Ctrl+Shift+Enter
Regards
Prince
On Thursday, December 6, 2012 8:50:48 AM UTC+5:30, Dhaval Shah wrote:
>
> Thanks a Lot Brother
>
> On Wed, Dec 5, 2012 at 11:14 PM, >>Excel Beginner<<
>
> > wrote:
>
>> Hi Dhaval,
>>
>>Please f
Hi Zeeshan,
I thinnk you need to write a macro that will unprotact your sheet when you
click on the pluse sign and uprotact your sheet when and expand outline
then protact your sheet .
Regards
Prince
On Wednesday, December 5, 2012 10:33:05 AM UTC+5:30, Zeeshan wrote:
>
> Dear Mates,
>
> I ha
Thanks a Lot Brother
On Wed, Dec 5, 2012 at 11:14 PM, >>Excel Beginner<< wrote:
> Hi Dhaval,
>
>Please find the attachment.
>
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> *
> *
> On Wed, Dec 5, 2012 at 12:26 PM, Dhaval Shah wrote:
>
>> Friends,
>>
>> pls go through the at
Thanks a lot Brother ... one more help needed also want Low
date Formula
On Wed, Dec 5, 2012 at 10:35 PM, Prince wrote:
> Hi Dhaval,
>
>
> Please see the attachment i hope it will help you.
>
> Regards
> prince
>
> On Wednesday, December 5, 2012 12:26:14 PM UTC+5:30, Dhaval Shah
I have this macro that I run everyday.
But it is a password protected excel sheet so Macro is asking me to put in
the password during macro is running. Here is where it asks password
Workbooks.Open Filename:=path1, UpdateLinks:=0
Sheets("DATA").Select
Workbooks.Open Filename:=path2, UpdateLi
lol (UK not US)
...
now that I look at it.. my response DOES look somewhat humorous...
perhaps I should've said "why you came to THIS FORUM" rather than "US"...
and hey! I DID say "We've" got a couple of problems here!
After all, "shared pain" is less, right? right?? well... maybe...
I realize
Paul,
Thanks for reply.
Yes I have couple problems :)
1. file is too big to send.
2. I've found solution (secound email) I've tried to resolve problem with the
procedure that you've made for me before, but for this instant I've done
something different.
3. now I've got different issue I'd like
Pawel,
We've got a couple of problems here.
(I guess that's why you came to US, right?)
The first problem is going to be that will need help understanding your data.
If you only want to check specific columns (C, F, Z, AC) then we can do that.
But if you want to look in the entire range, say:
ok I've got it
Function XOf(ParamArray Nums() As Variant) As Variant
''
' Add up the numbers in Nums
''
Dim N As Long
Dim D As Double
For N = LBound(Nums) To UBound(Nums)
If Nums(N) < 0 Then
Exit F
Hi All,
I'd like to create function that will check for me if the cell in the row has
value below 0. The issue of mine is that lookup value is not cosistly in the
same column. so could be like this:
I'm looking value in column C then F them Z then AC so there is not real
sequence for it.
Fun
18 matches
Mail list logo
