Dear Karthikeyansankaran,
Goto sheet view code their select worksheet from dropwdown.
Write the code .
ActiveCell.Interior.ColorIndex = 36
Warm Regards,
Gawli Anil
On Sun, Mar 10, 2013 at 5:53 PM, karthikeyan sankaran
karthikeyansankar...@gmail.com wrote:
Hi,
How to highlight ActiveCell
Any one ???
On Mon, Mar 11, 2013 at 12:22 AM, Santosh V eclerxsant...@gmail.com wrote:
Be,
Its not what i am looking for. Thanks for your respone.
On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn
betnmtdongna...@gmail.comwrote:
Use CommandButton1_Click to select sheet
Code:
Private
What I think you want to do is going to need some quite complex programming.
First, let me check that I have the right idea about what you want.
When any workbook opens on your computer, you want to have the the entire
row and the entire column of the active cell highlighted with a yellow
A sample workbook would be helpful to understand better.
On Mon, Mar 11, 2013 at 12:32 PM, Santosh V eclerxsant...@gmail.com wrote:
Any one ???
On Mon, Mar 11, 2013 at 12:22 AM, Santosh V eclerxsant...@gmail.comwrote:
Be,
Its not what i am looking for. Thanks for your respone.
On
I would try
Application.OnTime Now() + TimeValue(00:00:05), Sheets(Test).
CommandButton1_Click
First I think you need the . instead of the ! which you use in worksheet
functions. Next, you need a string in double quotes. Then where you want
the name of the file in the brackets you double up
Dear Amar,
Now it automatically select the row.
Pl see the attachment.
IS it OK?
Warm Regards,
Gawli Anil.
On Mon, Mar 11, 2013 at 1:55 PM, amar takale amartak...@gmail.com wrote:
Dear Anil
Can you solved my issue?
On Thu, Mar 7, 2013 at 4:33 PM, amar takale amartak...@gmail.com wrote:
Waiting for reply..
On Mon, Mar 11, 2013 at 2:07 PM, Santosh V eclerxsant...@gmail.com wrote:
Please find the sample file attached.
On Mon, Mar 11, 2013 at 1:41 PM, Abhishek Jain abhishek@gmail.comwrote:
A sample workbook would be helpful to understand better.
On Mon, Mar 11,
Dear Prabhakar
Please clear Following things
1.What is full year (how much Bonus wage is full year)
2.In body of mail u r showing greater than 1 but in Sheet u r writing
less than 1
3.What is prorata basis
Regards
Shrinivas
On Mon, Mar 11, 2013 at 4:03 PM, Prabhakar S H
Paste in H2 and drag down.
=IF(AND(C241000,G2=1),3500,IF(G21,0,((41365-C2)*3500)/365))
This is based on following assumptions:
- Bonus is calculated till 31.03.2013 @ Rs. 3500 for 365 days if bonus
wage is = 1 and employee joined before 1.4.12 (which means he worked
for
Hi Negi/Shrini,
The last one sent is working, thanks. But the button has to be on
'Consumed' sheet, instead of 'Main' sheet.
I think the code needs to be changed accordingly. I tried putting the
button in Consumed sheet but it did not work.
I hope you can fix this.
Thank you for bearing with
Thanks David...its working
On Mon, Mar 11, 2013 at 6:34 PM, David Grugeon da...@grugeon.com.au wrote:
This works
Application.OnTime Now() + TimeValue(00:00:05), Sheets(Test).CodeName
.CommandButton1_Click
Regards
David Grugeon
On 11 March 2013 21:52, Santosh V eclerxsant...@gmail.com
Hi,
Please find the attached workbook.
1. There are two tabs Test 1 and Test 2
2. The Header row is in row 5 and the data starts from row 6 onwards.
3. We have similar data in two tabs.
4. I need a Macro that will create separate workbooks based on individual
Mfr in column C.
5. But I need only
Dear Rahim
Pl specify your problem little bit more.
Warm Regards,
Gawli Anil
On Mon, Mar 11, 2013 at 11:29 PM, Rahim Sharieff
rahim.shari...@gmail.comwrote:
Hi,
Please find the attached workbook.
1. There are two tabs Test 1 and Test 2
2. The Header row is in row 5 and the data starts
Dear Abhi,
i missed to inform
8.33% with a maxim cap of 3500rs as bonus and for salary less than 10k.
On Monday, March 11, 2013 6:10:55 PM UTC+5:30, Abhi wrote:
Paste in H2 and drag down.
=IF(AND(C241000,G2=1),3500,IF(G21,0,((41365-C2)*3500)/365))
This is based on following
you cannot view more than 65536 rows in prior versions of excel.
if your excel version is 2007 or above, choose .xlsx file format while
saving your workbook.
On Tue, Mar 12, 2013 at 11:05 AM, Chaya chayamon...@gmail.com wrote:
Dear Experts,
I have a data base which contains
Sir,
How to View then, Please advice me ? what is xlsx format, you mean Ëxcel
97-2003 Workbook format ? i already did save as than, please suggest
experts..
Thanks,
Chaya
On Tue, Mar 12, 2013 at 11:19 AM, The Viper viper@gmail.com wrote:
you cannot view more than 65536 rows in prior
what version of excel are you using?
Ëxcel 97-2003 has the capability of holding maximum 65536 rows.
On Tue, Mar 12, 2013 at 11:24 AM, Chaya chayamon...@gmail.com wrote:
Sir,
How to View then, Please advice me ? what is xlsx format, you mean
Ëxcel 97-2003 Workbook format ? i already did
17 matches
Mail list logo