Hi Experts,
I need a macro which coluld do the following
1)top row contains integer 1 to 50 from B column to BZ column
2)other rows contain entries in column A
3)Also rows contains one entry beneath the integers in top row
the macro should read the columm corresponding to entries in co
Thanks Diwakar for lots of options, its really useful.
On Thu, Jul 5, 2012 at 4:45 PM, Divaker Pandey wrote:
>
>
> use this one
>
> Sub ChangeRowColor()
>
> Dim sheet As Worksheet
> Dim row_min As Integer
> Dim row_max As Integer
> Dim rowC As Long
>
> ' Select the used range.
> Set she
thanks noorain
On Thu, Jul 5, 2012 at 4:13 PM, NOORAIN ANSARI wrote:
> Dear Amit,
>
> Please try it..
>
> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Column = "3" And Target.Value <> "" Then
> Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
> End
Pls Follow Rule No 1
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
On Fri, Jul 6, 2012 at 11:49 AM, NOORAIN ANSARI
wrote:
> Hi DS,
>
> Please s
Hi DS,
Please see the attached sheet, hope it will help to you.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
-- Forwarded message --
From: Dhartikumar Sahu
Date: Wed, Jul 4, 2012 at 10:22 AM
Subject:urgent required vba code:: 2 lis
Dear Ashish Ji,
thanks but i m not getting the result, can you please send me the add
in or anything else for it
regds
ROHAN
On Thu, Jul 5, 2012 at 10:58 PM, ashish koul wrote:
> try this see if it helps
>
> Sub Scan_my_outlook_inbox()
> 'TOOLS ->Refrence -> microsoft outlook
> 'declare outloo
Hi All,
Similar to below one.
can any one help me in pasting a table from a excel sheet into a new
outlook window with left alignment.
Thanks in Advance.
Regards,
Vinay
-- Forwarded message --
From: David Grugeon
Date: 1 July 2012 17:10
Subject: Re: $$Excel-Macros$$ Automatic
---
You've been invited by Vishwanath to use Google Talk.
If you already have a Google account, log in to Gmail and accept this
chat invitation:
http://mail.google.com/mail/b-a4b38dd589-b737a56e20-WJs5adlbt2F2kMJWJK0mqrtMbFQ
To
---
You've been invited by Vishwanath to use Google Talk.
If you already have a Google account, log in to Gmail and accept this
chat invitation:
http://mail.google.com/mail/b-a4b38dd589-e244be0d28-ZcZgsAYcG4j1bijAsRsh5Purqhk
To
try this see if it helps
Sub Scan_my_outlook_inbox()
'TOOLS ->Refrence -> microsoft outlook
'declare outlook objects
Dim olapp As Outlook.Application
Dim olappns As Outlook.Namespace
Dim oinbox As Outlook.Folder
Dim oitem As Outlook.MailItem
Dim myItems As Outlook.Items
Dim i As Long
i = 2
'set ou
Awesome
Jhakaa.!!!
Thank You So Much...!:)
On Thursday, July 5, 2012 10:51:16 PM UTC+5:30, ashish wrote:
>
> try something like this
>
>
> a2 = sheet name
> b2 = cell adress
>
>
> Sub test()
> Sheets(Range("a2").Value).Range(Range("b2"
try something like this
a2 = sheet name
b2 = cell adress
Sub test()
Sheets(Range("a2").Value).Range(Range("b2").Value).Select
End Sub
On Thu, Jul 5, 2012 at 10:47 PM, Avinash wrote:
> Hi all,
>
> i want help regarding range selection from worksheet.
>
> i have created 1 macro to select spe
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets("sheet1").Select
ActiveSheet.Range("C7:BS37").Select
my macro should work on range which i have mentioned in the
Pankaj then check your filter settings of mails.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pankaj gmail account
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Jul 2012 13:19:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MVP Award..
thanks a lot Sam
Divaker
On Thu, Jul 5, 2012 at 7:57 PM, Sam Mathai Chacko wrote:
> Try this, might help.
>
> http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/
>
> If it doesn't, can you post your XML code?
>
> Regards,
> Sam Mathai Chacko
>
>
> On Thu, Jul 5, 2012 at 5
Try this, might help.
http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/
If it doesn't, can you post your XML code?
Regards,
Sam Mathai Chacko
On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey wrote:
> Hi Group,
>
> I made a custom menu and ribbon icon using xml in my wo
Dear Rajan,
Congrats...
--
*Best Regards,*
*Venkat *
On Wed, Jul 4, 2012 at 9:46 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 posts in June 2012 and helped ma
Dear All,
I want to Compress all the files(.zip) to the specified folders with the
password..Where i will have a passwords towards that file names..
have attached sample Password list..
I need a VBA Code...
--
*Best Regards,*
*Venkat *
*
*
*
*
*
*
--
FORUM RULES (986+ members already BANN
Since you already have it filtered why have separate sheets. Simply add rows at
top and use a subtotal(109. Or a separate sheet with sumifs for each city
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Deepak Rawat
Sent: Thursday, July 05, 2012 8:26 AM
To: ex
Hi
Its counts are not coming correct
Pls check on this.
On Thu, Jul 5, 2012 at 7:16 PM, Deepak Rawat wrote:
> Its working well
>
> Thanx!!
>
>
> On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Deepak,
>>
>> Please use below code...
>>
>> Sub N_spilit_Worksheet()
>> Dim i As
Dear SG,
Please open all files on share drive & then run this macro at your end.
Revert me if get any issues in it.
On Thu, Jul 5, 2012 at 7:12 PM, SG wrote:
> hi Noorain,
>
> thanks alot.I haven't tried this.Before trying, i would like to ask some
> queries.I'm not too good in macros...will
Its working well
Thanx!!
On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI wrote:
> Dear Deepak,
>
> Please use below code...
>
> Sub N_spilit_Worksheet()
> Dim i As Long
> Dim k As Long
> Dim j As Long
> Dim rng As Range
> Dim sh As Worksheet
> On Error Resume Next
> Set sh = ThisWorkbook.Workshee
hi Noorain,
thanks alot.I haven't tried this.Before trying, i would like to ask some
queries.I'm not too good in macros...will this macro reduce the size of
files placed at share drive or should i open all files on share drive &
then run this macro at my end??? Please clear my doubts on it.
Dear SG.
Please try it..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim ECol As Long 'Last Column
Dim lRow As Long
Dim BRow As Long 'Last Row
Dim Pi
Congrats Rajan this is the third time continuously. congratulation once again
Regards,
Lalit Mohan
On Thu, Jul 5, 2012 at 6:18 PM, Rajan_Verma wrote:
> Thank you all.. J
>
>
>
>
>
> Regards
>
> Rajan verma
>
> +91 7838100659 [IM-Gtalk]
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-m
I think Noorain's solution is the excellent among all replies.
gr8 Noorain.
Divaker
On Thu, Jul 5, 2012 at 6:22 PM, Rajan_Verma wrote:
> ** **
>
> ** **
>
> =SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
HI LOKESH
I think query is still not clear
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 05 July 2012 5:14
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ Working
=SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 05 July 2012 1:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macr
Thank you all.. J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Asa Rossoff
Sent: 05 July 2012 1:39
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Rajan Verma - Most helpful Member
Hi Experts,
I'm in crunch situation.Let me try to explain.We have some Excel files
named-1,2 & 3 saved on network share of pune & they are really very heavy
like 40 MB each. What i have to do is to fetch the data of current week for
eg. week-27.I have analysed them & the trend of data is irreg
Hi Group,
I made a custom menu and ribbon icon using xml in my workbook. I want to
keep selected the created custom menu everytime whenever workbook activated.
Divaker
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like P
use this one
Sub ChangeRowColor()
Dim sheet As Worksheet
Dim row_min As Integer
Dim row_max As Integer
Dim rowC As Long
' Select the used range.
Set sheet = ActiveSheet
'sheet.UsedRange.Select
' Display the range's rows and columns.
row_min = sheet.UsedRange.Row
row_max
Dear Sanjib,
Its not working & improting i need to import all Mail IDs from My Sent
& Inbox Folder, i need any macro for this
thanks
On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
wrote:
> Just follow follow the link
>
> http://support.microsoft.com/kb/295664
>
>
> On Thu, Jul 5, 2012 at 3:
*Congrats..Ashish & Dilip*. :)
On Thu, Jul 5, 2012 at 11:05 AM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> cong both of you
>
> Regards,
>
> Sanjib
>
>
>
> On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey wrote:
>
>> *Congrats..Ashish & Dilip, for your gr8 Achievement.*
>>
>> B
Dear Amit,
Please try it..
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = "3" And Target.Value <> "" Then
Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
End If
End Sub
*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelma
Just follow follow the link
http://support.microsoft.com/kb/295664
On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young wrote:
> Dear Group,
>
> how can i get all mail IDs from my outlook to excel to make a list of
> all IDs and Co., please help me out
>
> Thanks & Regds
>
> ROHAN
>
> --
> FORUM RULES
Dear Group,
how can i get all mail IDs from my outlook to excel to make a list of
all IDs and Co., please help me out
Thanks & Regds
ROHAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need He
Hi Experts
I need a macro which changes the FONT COLOR of ENTIRE ROW as per font color
of a particular cell in that row. Sample file attached.
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Dear Moderator,
i appreciate if any one gets award.
Four types of mails are filling my mailbox
*1. MVP Award*
*2. Introduce Yourself*
*3. Five Year Completion*
*4. Help ful Member*
Then why *Not Job posting* also this will help forum members too.
Regards,
Pankaj
On Thu, Jul 5, 2012 at 10:04 AM
39 matches
Mail list logo