The problem is that you cannot protect a protected sheet.
So once you use:
ActiveSheet.protect DrawingObjects:=True, Contents:=True, Scenarios:=True
then the line:
Activesheet.protect Password:=deck
does NOTHING, because the sheet is already protected!
you need to combine the two lines:
Hello,
i'm having trouble with a macro that i've sent up to:
1) unprotect a sheet with a password
2) do some filtering and set a print area
3) apply the password again
Looks like steps 1 and 2 are working fine but step 3 isn't working. After
running the marco I can click the Unprotect Sheet
*Hi**,*
*Hope you are doing great!!*
* Please find the requirement below **,* *If you find yourself comfortable
with the requirement please reply back with your updated resume with
details to this email id s.dak...@esskay-inc.com s.dak...@esskay-inc.com
and I will get back as soon as
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *AB Initio Developer or Lead *position in *Chevy Chase, MD**.
*Please find below the job description for the same and revert back to me
with your consultant updated profile and contact
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option Explicit
Private Sub CommandButton1-Click()
Dim Range As Integer
Dim UsedRange As Integer
Sheets(RegionalAreas).Select
check this Attachment..
ᐧ
On Thu, Jan 22, 2015 at 12:58 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi
Put your value in Cell A1 put below formula in B1 copy and paste it
next columns
=TRIM(MID(SUBSTITUTE($A1,,,REPT( ,99)),(COLUMN(A$1)*99)-98,99))
Cheers!!
ᐧ
On Thu, Jan 22, 2015 at
Formula is working Well. Nice Solution Vaibhav bhai.
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
Thanks for the function options. Look great but I would prefer to do with
VBA
23,34,56,57,60... would
become
23
34
56
57
60
etc
Thanks
Charles
On Thursday, January 22, 2015 at 7:42:29 PM UTC+13, sswcharlie wrote:
HI
Have cells that have had serial numbers entered (up to 50 serial
Elaborate more with Example
On 22 January 2015 at 12:12, sswcharlie swch...@gmail.com wrote:
HI
Have cells that have had serial numbers entered (up to 50 serial numbers)
each separated by a comma.
Is there a VBA argument that can take the cell and transfer each serial
number to its own
Nice solution Vaibhav Bhai.
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 thread
Cheers Buddy..
ᐧ
On Thu, Jan 22, 2015 at 1:08 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Formula is working Well. Nice Solution Vaibhav bhai.
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
Double Cheers to you.
--
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,
This code is not complete, do check report..
ᐧ
On Thu, Jan 22, 2015 at 11:20 AM, sswcharlie swch...@gmail.com wrote:
Hi
Excel2000
On code below I get a 'syntax' error. On row- Intersect. Code
off the net. Have tried some things but no luck. What have I missed ?
Option
Hi
Put your value in Cell A1 put below formula in B1 copy and paste it
next columns
=TRIM(MID(SUBSTITUTE($A1,,,REPT( ,99)),(COLUMN(A$1)*99)-98,99))
Cheers!!
ᐧ
On Thu, Jan 22, 2015 at 12:25 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Elaborate more with Example
On 22 January
Hi
Have checked and this is all the code I had.
What I want the code to do is to put the last number in a list in the text
box on user form.
Thanks for your help.
Charles
On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote:
Hi
Excel2000
On code below I get a 'syntax'
Hi Charlie,
Check this.
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 thread
Hi Vaibhav Bhai,
Thanks..!!
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 thread
Thanks...!!
--
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,
Dear All,
I have a one issue. I want the define in particular category.
eg:-
Value Category
Emp_code+Emp Name new code
Emp_name_Mob_No Old Code
Means:- Pre Numerical + Any String then write the* New Code* in Category
columns
Any
Hi
Chekc this attachment, press Apt + F8 and click on Macro1 to run macro.
On prompt select range B2:B15 for this data you will get output on output
sheet..Make sure you empty column A in output sheet before running macro
else your all data will get deleted bu macro from output sheet..
Its owesum...
Cheers~!!
ᐧ
On Tue, Jan 20, 2015 at 11:05 AM, Pravin Gunjal isk1...@gmail.com wrote:
Good Morning,
It's fantastic...
On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Dear Pravin jee
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or
check col. B in attachment
Cheers!!
ᐧ
On Wed, Jan 21, 2015 at 5:47 PM, Rajeev Ranjan 06raj...@gmail.com wrote:
HI,
please find the Sample data
Input Data are Value columns
output data are Category columns.
Value*Category*Description001_Anil Sikdhar_MPCG_VAINew
Dear Sir,
A sample file would help to understand the issue.
On Wed, Jan 21, 2015 at 4:45 PM, Rajeev Ranjan 06raj...@gmail.com wrote:
Dear All,
I have a one issue. I want the define in particular category.
eg:-
Value Category
Emp_code+Emp Name new code
HI,
please find the Sample data
Input Data are Value columns
output data are Category columns.
Value*Category*Description001_Anil Sikdhar_MPCG_VAINew
Codeinteger value+ String456_RAJENDRA Kewat_MPCG_VAINew CodeAP_Adecco_Maheshwar
Kumar.V_98660Old CodeString +
Hello,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Build Release consultant with TFS. *position in* Chevy
Chase, MD. *Please find below the job description for the same and revert
back to me with your updated profile and contact details at the
25 matches
Mail list logo