Hi Kumar,
For your 1st Question, you need to write the macro in Worksheet_Change
Event.
For your 2nd Question, yes you can get only formula text. You can use the
formula called FORMULATEXT
=FORMULATEXT(Cell_Refefence)
Note: FORMULATEXT is a new formula in 2013 Version of excel. Previous
Dear Sir,
1) will you suggest me the code.
2) how to use the formula in 2007, for that also if you suggest the code.
It will help me a lot.
thanks
Regards,
Kumar Bhanushali
Re: $$Excel-Macros$$ please suggest
XL Macros
to:
excel-macros
08-07-15 12:33 PM
Sent by:
excel-macros
Dear Sir,
1) Is there any way, that if any value is pasted in column, it should be
automatically round off to specified value.
2) Is there any way, that if cell having formula is copied and it will
paste to another sheet, but it will paste only formula text removing =
from it, not value.
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
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 +
I am not aware whether i should have to write this or not.. If it
not adequate post please discard this one but not banned me from this Forum.
what will be the duration for the same.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
You can finf excel vba 2007 published by o reily
On 20/09/2011, Rupesh Shrivastava rupesh.shrivastava1...@gmail.com wrote:
Hi,
Can anybody suggest me the name of the Best book available in the market to
learn VBA. Please suggest.
I have already one book Excel 2010 Power programming with VBA
Dear Rupesh,
I would suggest to check the Group's page for ebooks. Alternatively,
you can also google and download pdf books as per your choice. There
are many online tutorials available as per various expertise levels
You can also download ebook...
Hi All,
I am Sandeep one of the group member like you, I am living in West Delhi
Uttam Nagar wanted to Learn VBA( Macros ), Access and SQL.
if you know abt any institute, any faculty, any good book or any thing which
help to learn this Please Reply the mail or may ID sandeepxxxku...@gmail.com
11 matches
Mail list logo