Dear all,
I have written a simple procedure to fill cells with dates, it depends on
the current month and decide the range of the cells.
Can anyone suggest any room for improvement for my code?
Sub monthfill()
Dim myrange As Range
Dim mth As Integer
Cells.Clear
mth = month(Date)
Select
dear Noorani,
do you have material for intermediate level user in which macro and
other material related to advance is not included.
plz send me.
On Thursday, May 17, 2012 7:56:40 AM UTC+3, TARUN wrote:
dear Noorani,
do you have material for intermediate level user in which macro and
Hi Don,
Say for an example:
I have data from A to H
G col : HCol
: 5
: -5
Subtotal: 0
Now, what I want is ...copy the entire block to another sheet and delete
that zero subtotal block. Please do let me know if you need any more
information.
Thanks,
Srini
On
Hello Siraj,
Please give more information , attach an example.
On Thursday, May 17, 2012 8:47:26 AM UTC+3, Siraj Momin (BTG) wrote:
Dear Excel Group Friends
Is there any way that certain rows of a sheet is repeated at the bottom of
each page……
Siraj
--
FORUM
Thanks Asa
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Wed, 16 May 2012 16:08:09
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE:
Hi,
Excel having options for *Rows to Repeat at Top *- Press Alt + P + I,
Select the Range and OK.
There is no in-build function for *Rows to Repeat at Bottom*, You can try
below codes to show it in footer.
Sub MyFooter()
Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range
From : Subu
Thanks for the post
My follow up replies are shown as bullet points and are shown within
-- / lines
On Wednesday, May 16, 2012 6:59:34 PM UTC+4, Don Guillett wrote:
Your example doesn’t help much. An ACTUAL sample is
Dear Siraj Momin,
please follow the steps
1. go to file
2. paresetup
3. choose sheets
4 rows to repeat at top
ok
regards,
Sanjib
On Thu, May 17, 2012 at 11:17 AM, Siraj Momin (BTG) smo...@ccc.ae wrote:
Dear Excel Group Friends
** **
Is there any way that certain rows of a sheet is
From : Subu
Dear Rajan other list members
I'm a complete novice in VBA. Still, I think there is a problem in this
reply / code below
- When you reach this statement ...Worksheets(intLoop).Paste...,
Intloop is still = 1. i.e. value of
Hi,
Anybody have total Floor's Electrical Load Calculation Sheet.Xls
If YES then request you to forward me the same
*
*
*
*
*JOCKY*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Hi,
Check this link,
http://www.jiguparmar.com/1_22_Electrical-Engineering.html
*
*
* MARIES*
Excel Inspiration http://xcel-inspiration.blogspot.com/
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Dear experts
Excel macro for sendin outlook emails from Specific Templet With
Attachments formats of .PDF .htm
Thanks in Advance
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
Give a try to this link..
http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Thu, May 17, 2012 at 11:07 AM, Seraj Alam seraj.ala...@gmail.com wrote:
Hi,
U can use this formula in data
Hi
Please find the attached Sheet
It provide you a dynamic and sorted list in List Validation
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Seraj Alam
Sent: 17 May 2012 11:07
To:
Thanks to all! I will try and revert back to you!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 17 May 2012 04:21:51
To: excel-macros@googlegroups.com
Reply-To:
Hi,
First you Can give Name ranges instead of Static Range like B1:B31
Second :
You can create a Function for these lines to reduce the Lines from your code
With myrange.Cells(1)
.Value = DateSerial(Year(Date), month(Date), 1)
.AutoFill Destination:=myrange,
Please attach sample file to get Exact result J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sreenivas kammari
Sent: 17 May 2012 12:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
One way is to save that row somewhere As an image, then Give that image in
footer J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Maries
Sent: 17 May 2012 1:23
To: excel-macros@googlegroups.com
Hi Sabu,
Intloop can not be 1 if your workbook have at least one worksheet with data
, IntLoop is actually starting From first Blank Worksheets Index,
Suppose if you have 5 filled workhseets then 10 blank worksheets, IntLoop
will be start from 6 and end with 10
Regards
Rajan verma
+91
If you can send the query with parameters and Calculation we can make it for
you J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jocky Beta
Sent: 17 May 2012 2:36
To: excel-macros@googlegroups.com
try
Sub setdvlist()
With Range(a2:a Cells(Rows.Count, 1).End(xlUp).Row)
.Sort Key1:=Range(A2), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
.Name = dvlist
End With
With Range(b2).Validation
.Delete
.Add
Please attach your sample file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Burbonizer
Sent: 17 May 2012 3:53
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA If statement
Hi
Provide file
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: sreenivas kammari
Sent: Thursday, May 17, 2012 1:58 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Delete Zero subtotal blocks
Hi Don,
Say for an example:
I have data from A to
Hi
I cannot send you the complete file because it is big file due to group
restriction I have set example, in the file suppose I want to repeat
rows A73:J76
I will be fixing these rows at the last rows of the sheet because my
data is large, that I want to repeat at the bottom of the each
We are not asking for your all data, you can send some sample data with your
Code
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Burbonizer
Sent: 17 May 2012 8:32
To: excel-macros@googlegroups.com
Dear Group,
Macro required which generate the same copy of sheet but values only.
Regards,
Aamir Shahzad
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Sub makevalues()
ActiveSheet.UsedRange.Value = _
ActiveSheet.UsedRange.Value
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Thursday, May 17, 2012 12:15 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Values 2 New
Dear
Try this One:
Sub MakeCopyofValues()
Dim rngRange As Range
Dim wksSheet As Worksheet
Set rngRange = Application.InputBox(Select A Range, , , , , , , 8)
rngRange.Copy
Set wksSheet = Worksheets.Add
wksSheet.Range(A1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
*Hi;*
* *
*Greetings from Sigmatechnologies!*
* *
*I Hope you are doing great…*
* *
Let me know if you have anyone for the below role. This is a hot need from
our client.
Network Security Engineer
Location: Dublin, OH, PA, NJ,
Rate: depending on the exp
Duration : 6 months
• expert
Don,
Your macro is convert the sheet to values only not creating copy of sheet.
Rajan,
Your macro is showing error.
Regards,
Aamir Shahzad
On Thu, May 17, 2012 at 10:37 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Try this One:*
Sub MakeCopyofValues()
Dim rngRange As Range
Did you select the range in input box??
Can you share the screenshot of Error?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 18 May 2012 12:46
To:
REMOVE THE ALL BLANK LINES BETWEEN LINES OF CODE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 18 May 2012 12:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
*Hi;*
* *
*Greetings from Sigmatechnologies!*
* *
*I Hope you are doing great…*
* *
Let me know if you have anyone for the below role. This is a hot need from
our client.
Network Security Engineer
Location: Dublin, OH, PA, NJ,
Rate: depending on the exp
Duration : 6 months
• expert
ok Rajan now code is working fine but it's removing the formating.
Aamir Shahzad
On Fri, May 18, 2012 at 12:24 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
*REMOVE THE ALL BLANK LINES BETWEEN LINES OF CODE*
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
*From:*
Sub MakeCopyofValues()
Dim rngRange As Range
Dim wksSheet As Worksheet
Set rngRange = Application.InputBox(Select A Range, , , , , , , 8)
rngRange.Copy
Set wksSheet = Worksheets.Add
wksSheet.Range(A1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
thanks rajan for your expertise. But if format started from B2 to H10 when
run the code, sheet format automatically starts from A1 to. Please see
amend that create the new copy values sheet except copy.
Aamir Shahzad
On Fri, May 18, 2012 at 12:35 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Thank you so much Rajan you are really asset of this group. Can you guide
how to become the expert like you in formulas macros.
Aamir Shahzad
On Fri, May 18, 2012 at 12:50 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
I think it will be final J
Sub CreateCopy()
ActiveSheet.Copy
Hi Siraj,
I do not think so. Not automatically.
You would have to have the rows repeated on your worksheet at appropraite
places, or use a macro to temporarily insert those rows, print the sheet,
and then remove them again.
The most common solution, I think, is to use the page footer
i need material on excel shortcuts pls send if ne one
have
--- On Thu, 17/5/12, Tarun Mondal tarunmondal1...@gmail.com wrote:
From: Tarun Mondal tarunmondal1...@gmail.com
Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION
To: excel-macros@googlegroups.com
Date: Thursday, 17 May,
sir if u hav file related to use short cuts for using desktop and microsoft
word pls send
--- On Tue, 15/5/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
From: NOORAIN ANSARI noorain.ans...@gmail.com
Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION
To:
Dear all,
Thanks for your help!
2012/5/17 dguillett1 dguille...@gmail.com
Sub dates()
days = Day(DateSerial(Year(Date), myMonth + 1, 1) - 1)
MsgBox days
Set myrange = Range(b1: b” days)
With myrange.Cells(1)
.Value = DateSerial(Year(Date), Month(Date), 1)
.AutoFill
*Dear Expert,
Please anyone help me on my query, the query is in the attached file.
i have been looking on this and trying for past couple of days back. thank
you experts.
*
Thanks Regards,
Deba Ranjan P
-- Forwarded message --
From: Deba Ranjan
Hi Asa Rossoff
Thank You for your advice, actually the problem is it is an small box
with border are there which I want to repeat at bottom and in page
footer this border option is not there, marries on this group provided
me the macro to repeat particular rows at the bottom but the borders
Please help...
I have tried adding formula in Pivot but getting an error #DIV/0! .
I want Avg cost per Visit. There is a column for cost(column head A)in of
each cab getting repaired also cab registration number (column head B)is
maintained.
Best Regards,
Amit
Hi Amit,
Can you send a sample dataset?
Regards,
Andy
On Fri, May 18, 2012 at 10:22 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
Please help...
** **
I have tried adding formula in Pivot but getting an error “#DIV/0! .
** **
I want Avg cost per Visit. There is a
FYI, please find attached sample sheet...
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Aindril De
Sent: 18 May 2012 10:28
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Addition of Formula in Pivot
Hi Amit,
Can you
46 matches
Mail list logo