Dear Dilip,
I believe that you might have answered my query already but somehow it was
missed or deleted in my folder. Could you please share it again so that I
can go through it again.
Thanks for your efforts and suggestion towards this.
Regards,
Sharma
On Wed, Jun 3, 2009 at 7:36 PM, Dilip
Hi Akshu,
The best and quick way is Text - to -Column feature of the excel.
I believe, if we do it by a function then we might have to drag that to the
end of the columns/ rows (IV or 65536) or else VBA is the sure shot answer
for your query.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B
Hi Harish,
Check if this problem occurs only with Excel. If not, then go to Task
Manager (Alt + Ctrl + Del) and check how many programs are running in
background and how much is the memory consumption by them. Now you can
control them as per your needs.
For windows, Go to run and type msconfig
Hey Dilip,
Thanks for reply, but it doesn't work for me.
I have observed that this is problem with *only *this excel file.I
tried on *different system*(more than 10 system), same problem occurs.I also
tried to save this excel file when no other file was being used,but same
Dear All,
Please help me on attached sheet.
Thanks
Sachin Shukla
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
Try the macro
do the following and then copy the code below in a module
cell E1 = '00:00:01
cell E2 = validation list with 2 option active, inactive
Sub check_prices()
'created by Nishant Jain (nishantjai...@gmail.com)
Application.OnTime Now() + TimeValue(Range(E1).Value), run_code
End Sub
Sub
Dear All
my data started in colomn A cell no 6 upto a50(Cell a1 to a5 is empty),
using Vba I need to find the next empty cells address
Could help me to find the next emty cell address through Vba in perticular
coloumn
Regards
Grlinks
www.grlinksindia.com
try the below
dim row_count as double
row_count = 6
do while activesheet.cells(6, column_number*).value
msgbox row_count
loop
* enter the column number here
Nishant
On Jun 4, 6:10 pm, grlinks-karthik grli...@gmail.com wrote:
Dear All
my data started in colomn A cell no 6 upto
**
*Check the attached file*
On Thu, Jun 4, 2009 at 3:32 PM, Sachin Shukla sachina...@gmail.com wrote:
Dear All,
Please help me on attached sheet.
Thanks
Sachin Shukla
--~--~-~--~~~---~--~~
!!!
Can you simplify that a bit?
I think you may get a solution if you attach an excel file containig
data like:
Data in a sheet (all inputs of data, showing all the possibilities)
Required computation in the next
Desired Output in another (exactly as you need it)
Thanks Nishant...
Again code does not work when value in cell A1 is updated dynamically
through an external source. I create a DDE link and paste to cell A1
so prices are updated automatically..
On Jun 4, 9:24 am, Nishant Jain nishantjai...@gmail.com wrote:
Try the macro
do the following and
Hi dear Steve,
This is the solution :)
Create:
1) A combobox ComboBox1
2) A Command Button CommandButton1
and copy the following code
--
Dim x As
Hi Harish
If this is related to excel VBA code, then you can use following which I use
generally to fasten the execution of the code.
Speed up code and stop screen flickering:
==
Sub NoScreenRePainting()
Application.ScreenUpdating=False
'Your code here.
Do it simply without using a macro:
1) Insert a row at the top
2) write the formula in the inserted row (say the column is A and
the inserted row is 1) =COUNTA(A2:A9)
(it will give the count of non blank cells in the column) drag
the formula for the entire row
3)select the cells in
Dear members,
I would like to recognize the efforts of few new members who are
contributing a lot in the group by solving excel and macros queries.
Few names I personally observed are :
1) Dilip pandey
2) FABIO_XL_Master
3) YU
4) Nishant Jain
5) anyone who is helping others
Along with you ,
Hi
I am really thankful to you that u made this group
i m learning alot
this is really gr8
i appreciate your efforts
regards
ruchi
On Thu, Jun 4, 2009 at 10:34 PM, ayush jain jainayus...@gmail.com wrote:
Dear members,
I would like to recognize the efforts of few new members who are
Hi,
Try this:
A = Cells(Rows.Count, 1).End(xlUp).Row + 1
This will give you the first blank row number
Regards - Dave.
Date: Thu, 4 Jun 2009 18:40:46 +0530
Subject: $$Excel-Macros$$ find next empty cell address
From: grli...@gmail.com
To: excel-macros@googlegroups.com
Dear All
my data started
I am trying to sort special numbers in a long list of telephone
numbers (7 digits). For example:
a. Highlight yellow those numbers which have 3 consecutive digits (eg
2281555).
b. Highlightt blue those numbers which have two double numbers (eg
4431122).
c. Highlight green those numbers which are
Hi Mike,Check the article below
http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html
This helps in copying many small files into a single excel workbook and each
file gets it's own sheet.
On Mon, Jun 1, 2009 at 1:34 PM, mmccaws2 mmcc...@comcast.net wrote:
Hi
Hi guys,
I have a web page with links to excel spreadsheets on a server. The
problem I'm having is that when I update the spreadsheet and upload a
new version to the server then the links from the web page cause a
copy cached on the user's local machine to open instead of calling the
new
Dear All,
I want to know the how i can find the *repeat or duplicate* value in same
column or row.(without Advance filter)
--
With Love,
Mahesh Bisht
--~--~-~--~~~---~--~~
-
Some
If you are going to put a checkbox in each cell in column B, then you would
be better off using data validation instead of the checkbox due to
performance issues. Below is the explanation of how to do this?
To put a dropdown list in cells, users can then select, in your case Yes or
No from a
I have 2 vba modules that are both within a protected project. I wish
to remove one module via code from the other module. I have this in
module1:
ThisWorkbook.VBProject.vbcomponents.Remove
ThisWorkbook.VBProject.vbcomponents(module2)
It works fine IF I have the project unprotected, but the
Dear Mahesh,
You can use Conditional formatting annd use the following Formula in it:
=COUNTIF($A$1:A1,A1)1
Regards,
Andy
On Fri, Jun 5, 2009 at 11:08 AM, Mahesh mahender.bi...@gmail.com wrote:
Dear All,
I want to know the how i can find the *repeat or duplicate* value in same
column or
Hi Mahesh,
One way is to select all cells in the column:
(I have assumed Col A, starting Row 2)
Select conditional format, formula is, then enter:
=COUNTIF($A$2:$A$1000, A2)1
Set the format you want - say red bold text.
Hit ok
All duplicates will be red bold.
Change the range and starting
25 matches
Mail list logo
