Thanks for information.
I'm unable to get results, code is working fine.
Thanks
Anand
On Wed, Dec 18, 2013 at 2:18 AM, Ravinder ravinderexcelgr...@gmail.comwrote:
PFA, first select folder from where you want to get result, after
getting result you can open folder by clicking on link.
What problem you are facing you select main folder in which ur subfolders
are available. This will give only sheet and file name of empty sheets.
From: ANAND S [mailto:anand...@gmail.com]
Sent: Wednesday, December 18, 2013 3:20 PM
To: Ravinder
Cc: excel-macros@googlegroups.com; Soum
Subject:
Thanks for your valuable time spending on my requirement.
I'm not getting sheet and file name of empty sheets and its not moving each
sheet to find the blank cells.
If is possible to share your contact no, it will be great to me to discuss
with you.
Thanks in Advance.
Anand
On Wed, Dec 18, 2013
Dear team,
Plz Help problem not resolved same issue file still not open so plz ...
regards.
Nitin Kumar
On Tuesday, December 17, 2013 11:59:30 AM UTC+5:30, nitin kumar wrote:
Dear Kuldeep,
this software shows cant remove the VB password
PLz Help file is below,
Pfa,
Regards,
Nitin
In Macro use conditional Formatting..use Top 10 option..
Regards,
Amit Desai - MIS Manager
M: +91 9867232534
[cid:image001.jpg@01CEFC07.8BEB7E40]http://www.merucabs.com/mobile/
[cid:image002.jpg@01CEFC07.8BEB7E40]goo.gl/gHTB5E[cid:image003.jpg@01CEFC07.8BEB7E40]goo.gl/QNQP51
From:
Use below lines.. but you need to change these lines as per your code.
Userform1.Hide 'To hide the userform if it is with name Userform1
myCriteria1 = Userform1.textBox1.value
myCriteria2 = Userform1.textBox2.value
Sheet1.Range(A1).autofilter 2, Criteria:= = myCriteria1, xlOr,
Criteria:= =
Dear Amit Sir,
I want a fix sheet where top 10 Requestors for each company will update
automatically.
For example :
there will be two sheet in excel file
one is master
second is Top 10 Requestors.
once i put date in master file the second sheet will be update with latest
top 10 Requestors
Dear Prafull,
Let your Macro use the master file, get Top 10 list from Master from that
list you can just re-fresh the chart.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Prafull Jadhav
Sent: 18 December 2013 16:00
To: excel-macros@googlegroups.com
'Hi Bill, I redid the code, see if it works now:
Sub SplitRange()
Dim FirstPartM As String
Dim SecontPartM As String
Dim FirstPartH As String
Dim SecontPartH As String
Dim i As Long
Dim Lastrow As Integer
Lastrow = Cells.Find(*, [A1], , , xlByRows, xlPrevious).Row
i = 1
For i = i To Lastrow
If
[image: Christmas Greetings Glitter Scraps]
[image: Christmas Greetings Glitters]
--
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-8586978644
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really
Besole,
You are 100 % correct. My spreadsheet has over 25,000 entries. I only sent
you a small subset of 25 or so and thought I had covered all bases. This
was not the case. My error. .
On Wednesday, December 18, 2013 11:07:45 AM UTC-5, Basole wrote:
Bill, this example of data that had
Hi Bill, press the F8 key on VBE (VB editor) to check what line and what
kind of character the error occurs.
Basole.
Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q escreveu:
Hi,
The macro below currently finds and removes selected characters that it
find. It
Basole,
No error occurs when running the code. It just ignores the single digits or
where numbers do not have a + or - before them. I only noticed this when
running the marco through the whole spreadsheet where it encountered a
number without a = or -.
On Wednesday, December 18, 2013
Hi
I am trying to connect IE 9 using vba and create a loop download data. Any
help.
--
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,
Bill, try this code in the B column, passes the data from column A
without the character, and insert the + character.
'first of all, it is advisable to make a back-up of data.
Sub InsertChr()
Dim orig, rev, RevL, RevR, ss, result
Dim Lastrow1, Lastrow2 As Integer
Dim i As Long
Lastrow1 =
Dear All,
Very good morning and have great day.
Wating for output.
Regard,
Prafull Jadhav.
9920553518
Dear Prafull,
Let your Macro use the master file, get Top 10 list from Master from that
list you can just re-fresh the chart.
*From:* excel-macros@googlegroups.com
Provide website and data you want to extract.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Thursday, December 19, 2013 4:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ie
Hi
I am trying to connect IE 9
I am trying to connect Google \ analytics and pull report.
On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote:
Provide website and data you want to extract…
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
Any website link or url
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of B.N.Chethan Kumar
Sent: Thursday, December 19, 2013 10:41 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Ie
I am trying to connect Google \ analytics and pull
Success. Flawlessly beautiful.
Many thanks again Basole !!
On Monday, December 16, 2013 8:09:31 PM UTC-5, Bill Q wrote:
Hi,
The macro below currently finds and removes selected characters that it
find. It works great. No issues.
What I would like is this to be modified so
Hi Experts,
How do I write function that return last row in excel using VBA
On Thu, Dec 19, 2013 at 9:43 AM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear All,
Very good morning and have great day.
Wating for output.
Regard,
Prafull Jadhav.
9920553518
Dear Prafull,
Let your
21 matches
Mail list logo