Dear VBA Exoerts,
Can u please help me in getting Text value in Pivot value field.
Thanks,
Nilkanth Raval
Sent with AquaMail for Android
http://www.aqua-mail.com
--- Forwarded message ---
From: Nilkanth Raval
Date: December 2, 2015 6:10:16 AM
Subject: $$Excel-Macros$$ FW: Get text value in p
Hi Abhishek,
It has been resolved, attached is the Excel file. Thanks for your help.
Regards,
Vijayendra
2016-02-03 15:08 GMT+05:30 Vijayendra Rao :
> Thank you very much Abhishek your help. I am facing issue in name and
> verifier column as you have given number of character 30, If any employe
Dear Paul
Really great thanks for help.
Regards
Shrinivas
On Fri, Feb 5, 2016 at 6:08 PM, Paul Schreiner
wrote:
> Change your macro to:
> Sub MyFilter()
> Dim lngStart As Long, lngEnd As Long, thisWB As Workbook
> Dim NewWB As Workbook
>
> Set thisWB = ActiveWorkbook
> '
There MAY be an option in Excel to prompt for this.If so, then it may be
selected when the software is installed, or in a Profile.
If that's the case, it's unlikely we could programmatically change the Excel
settings.
Glad the macro worked! Paul-
“Do all th
Paul Schreiner:
1. Your second solution of creating a macro worked. Thank you! You
definitely are an Excel guru.
2. Initially, when I unprotected each sheet, re-selected the cells to lock,
selected Lock in the Protection tab, selected a cell which was not locked,
set the Protect password, saved
What version of excel are you using?I've never had that happen.
There ARE a couple of things you can try or check:
In the protected sheet, what cell is "selected" when you protect the
sheet?Sometimes, if you have a locked cell selected, when you protect the
sheet, it is STILL selected.So, when yo
Excel Experts:
1. I locked selected cells in a spreadsheet (which contain formulae) and
set Protect with a password.
2. Each time a user opens the spreadsheet, the "Unprotect Sheet" password
dialog box prompt comes up.
3. Is there a way I can suppress this dialog box from coming up? I want the
u
in the attachment, I need a macro when I run it, this macro download the
files and save it at the particular area on the desktop or partition d,
whatsoever.
thanks in advance
--
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
The problem is that your macro starts with the first selected row and moves to
the last selected row.
following these steps,the first row is evaluated, if it is DELETED,then the
second row moves to the first postionand the third row moves to the second, etc.
at the next iteration of the loop,the
Hi,I give u the following code you can run and get what u expect. For the next
time u have to change the j value(i.e.,columnvalue,A=1 B=2 etc) to 6 to 7, and
next time this should be 8 to 9.Or if u don't mind in over printing the data,u
can put j value = 4 to 33.It is upto u.Here the row is fixe
look at the attachment, in this file I've a macro when i run it, the macro
does not remove the jpeg extension URL at once but we have to run it again
and again then it removes the jpg.
REQUIRED
I need a macro when i run once it removes all the jpeg extension URL except
others
thanks in advance
-
On Friday, February 5, 2016 at 6:54:21 PM UTC+5:30, Saurabh Karangutkar
wrote:
>
> HELLO PAUL YOU HAVE BEEN A GREAT HELP . BUT I M JUST A AMATEUR IN MACROS
> SO CAN YOU DO THE NECESSARY CHANGES AND SEND ME THE UPDATED TOOL . I HAVE
> UNPROTECTED THE SHEET SO YOU CAN MAKE THE NECESARY CHANGES
HELLO PAUL YOU HAVE BEEN A GREAT HELP . BUT I M JUST A AMATEUR IN MACROS
SO CAN YOU DO THE NECESSARY CHANGES AND SEND ME THE UPDATED TOOL . I HAVE
UNPROTECTED THE SHEET SO YOU CAN MAKE THE NECESARY CHANGES ..
On Friday, February 5, 2016 at 6:38:13 PM UTC+5:30, Paul Schreiner wrote:
>
> OK, ini
OK, initially:- The "Main" sheet is protected (luckily, without a password).
The protection does not allow locked cells to be selected. The sheet was
protected with the a locked cell selected. Therefore, when the macro tries to
select the sheet "Main", an error occurs.Solution: Unprotect the
Change your macro to:Sub MyFilter() Dim lngStart As Long, lngEnd As Long,
thisWB As Workbook
Dim NewWB As Workbook
Set thisWB = ActiveWorkbook
'-
' Create a new workbook
'-
Workbooks.Add
Dear Paul
Thanks for reply.
Cant get it.
Can you please modify it for me and send it back
Thanks in Advance
Regards
Shrinivas
On Thu, Feb 4, 2016 at 6:16 PM, Paul Schreiner
wrote:
> In your macro, you CREATE the new workbook:
>
> Workbooks.Add
> ActiveWorkbook.SaveAs Filename:=thisWB.Pat
Paul,
Thanks a ton. I will verify this code and get back to you
Regards,
Karthik
On Thu, Feb 4, 2016 at 7:54 PM, Paul Schreiner
wrote:
> I threw this together from some macros I created several years ago.
> I tested it and cleaned it up a bit.
>
> To insert it into your VBproject:
> save it to
17 matches
Mail list logo
