Dear Friends
I would like to delete the repeated row from the attached sheet.
E.g. Row No. 3, 5, 7 and so on up to row no.5000
Can someone help me to this by macro. Thank you,
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:
Hello Experts,
I am looking for an excel add-in that will enable Autocomplete from any
column or Sheet within a workbook
For example, lets say i have a sheet called "Accounts" where I have the
following:
A1 - Office Supplies
A2 - Marketing
A3 - Auto Expense
A4 - Payroll
If I go to *A5* and sta
No,
Just use this
ActiveCell.Copy
Sheet1.Range("B1").PasteSpecial* xlPasteValues*
*
*
*will paste only values*
*
*
*regards*
*prince*
On Friday, April 12, 2013 6:02:35 PM UTC+5:30, alanth...@gmail.com wrote:
>
> I want a user to be able to paste text into a cell but not change the
> format (e.
Excel Filters don't allow you to use more than two criteria.
If you're wanting to do something beyond two, you'll have to use some other
method.
You could create a "flag" column.
In the macro, reset the "flags" and then process the records, comparing it to
your criteria.
Set the "flag" for each r
Thanks Paul, this works for 2 criteria. What should I do for a third
criteria?
the following does not seem to work:
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1, Criteria1:="<>BALANS
- PASSIVA", _
Operator:=xlAnd, Criteria2:="<>WINST- EN VERLIESREKENING
(V&W)", Opera
Did you try recording the macro?
When I did, the macro looked like:
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1, _
Criteria1:="<>BALANS - PASSIVA", _
Operator:=xlAnd, _
Criteria2:="<>WINST- EN VERLIESREKENING (V&W)"
Paul
Seem to be having problems specifying this. I tried the following:
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1,
Criteria1:=Array( _
"<>BALANS - PASSIVA", "<>WINST- EN VERLIESREKENING (V&W)"),
_
Operator:=xlFilterValues
"BALNAS - PASSIVA"
I want a user to be able to paste text into a cell but not change the
format (e.g., text alignment) of the cell. The cells are on a protected
sheet, but these are unlocked. The content that will be pasted may be
copied from any source (e.g., a text editing program).
Is this possible?
Tha
Is there a way to disable the user editing the contents and size of a shape
but allowing them to drag and drop the shape?
I have shapes containing formulas. I would like the user to be able to
change the position of a shape but not edit its content (the formulas) or
size. Is there a way to do
thanks
On Friday, April 12, 2013 9:46:40 AM UTC+2, colmkav wrote:
> Hi,
>
> how do I exclude items using VBA code? I thought I would get the code
> using record macro but it only gave code to include items.
>
> eg
> Range("A13").Select
> ActiveSheet.Range("$A$13:$T$763").AutoFilter F
By saying, formula or a macro I meant that either way would be good for me..
Right now i cannot attach anything - forbidden by network policy here at
work.
Let me see if later in the evening.. ;)
thanks very much for he reply.
On Friday, April 12, 2013 11:32:54 AM UTC+2, Abhi wrote:
>
>
> Quot
Thanks Abhishek..
This is really very usefull..
Regards,
Rahim
On Fri, Apr 12, 2013 at 2:59 PM, Abhishek Jain wrote:
> Sorry the earlier file fetches all files from a folder.
>
> If you want to list only excel files or of any other type, this gives an
> excellent choice. This has many other fu
Quote:
need is a formula or a macro to formulate two new columns
Unquote:
Did not understand this part. Could you please share a workbook and be more
specific?
Regards,
On Fri, Apr 12, 2013 at 1:21 PM, Mateo wrote:
> Hi there,
>
> One small question:
>
> I recently got a document scanner that
I am not having any problem in replacing the data in the file you attached.
Just a note: Excel will not find the result of any formula by its value
until you set it so.
On Fri, Apr 12, 2013 at 1:01 PM, amar takale wrote:
> Dear Experts
>
> There are problem in sheet regarding replacement.If I
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1, Criteria1:=Array( _
"*<>value to exclude*", "*<>value to exclude*", "*<>value to exclude
*", _
Operator:=xlFilterValues
Replace "value to exclude" with your values.
HTH
On Fri, Apr 12, 2013 at 1:16 PM, colmkav wrote:
> Hi,
>
Does this help ?
On Fri, Apr 12, 2013 at 1:56 PM, wrote:
> I have worked on macros but not at a advanced level. Now i have been asked
> to do the following and need help
>
> 1. list down all excel files if a folder is selected by a user. i have
> created the browse button which takes me to bro
Something like this ???
http://stackoverflow.com/questions/8423300/html-to-pdf-through-vba-using-pdfcreator
On Fri, Apr 12, 2013 at 12:36 PM, LAKSHMAN PRASAD wrote:
>
> Dear expert
> I have a excel file, in a sheet contain some details with URL, is there
> any formula add-on or marco to print a
Dear Lakshman,
I got your point, i am not sure i can do, but i can only try as i am a
very new learner. After all our experts will surely tackle out this query.
Regards,
Chaya
On Fri, Apr 12, 2013 at 1:14 PM, LAKSHMAN PRASAD wrote:
> Dear chaya
> Thanks for prompt reply, but I want to print
I have worked on macros but not at a advanced level. Now i have been asked
to do the following and need help
1. list down all excel files if a folder is selected by a user. i have
created the browse button which takes me to browse folder whre i can select
a folder.also created a fetch command
Dear Chaya
Thats Perfect.I done it now
Thank very much share your experience
Regards
Amar
On Fri, Apr 12, 2013 at 1:06 PM, Chaya wrote:
> Dear Amar ,
>
>Couple of days back, i too face the same problem. But when i close
> every excel from the Task Manager Application and started again the e
Hi there,
One small question:
I recently got a document scanner that scans the values of name, surname,
type of document and number of document.
This data is automatically entered in an Excel file undere their respective
columns.
Now what I need is a formula or a macro to formulate two new co
Hi,
how do I exclude items using VBA code? I thought I would get the code using
record macro but it only gave code to include items.
eg
Range("A13").Select
ActiveSheet.Range("$A$13:$T$763").AutoFilter Field:=1,
Criteria1:=Array( _
"10125014", "11394750", "2234200120", "2234600
Dear Amar ,
Couple of days back, i too face the same problem. But when i close every
excel from the Task Manager Application and started again the excel file,
then i could able to do. Please try might it will help you.
Hope that this is not a solution but my experience.
Regards,
Chaya
On
Dear Experts
There are problem in sheet regarding replacement.If I replace anything
(Ctr+H) in this sheet then show error of formatting.I dont know what is
exact issue,I try many time but not sucess.
Pls tell me what is issue.
Please do the needful. Thank you
Regards
Amar
--
Are you =EXP(E:RT
Dear Lakshman,
If you have a PDF creater Installed, you can use this code, Just i
recorded.
Sub PrintUrl()
Sheets("Sheet1").Select
Range("D2:D63").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Application.CutCopyMode = False
Activ
Dear Kuldeep,
Please find the attachment for your requirement.
Actually i got this formula from this forum. just sharing you.
You need to copy and paste down the formula in A colomn, thats all.
Regards,
Chaya
On Fri, Apr 12, 2013 at 12:43 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> I w
Hi Experts,
I want to all sheet name in column wise. See attachment.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
yo
Dear expert
I have a excel file, in a sheet contain some details with URL, is there any
formula add-on or marco to print all URL details in a PDF file.
Lakshman Prasad
--
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 p
28 matches
Mail list logo
