Hi,
Can we do this using VBA macro? I understand that excel will struggle while
searching. But is it possible? If yes, could anyone help me out? Thanks
On Wed, Apr 24, 2013 at 2:45 PM, Kanwaljit Singh kanwal...@gmail.comwrote:
Hello Sir,
What I understand that is
--You are using a
Dave, you might want to explain that a bit. Not exactly sure what you are
saying.
On Thu, Apr 25, 2013 at 5:40 AM, David H dhermu...@gmail.com wrote:
I am using an excel spreadsheet in conjunction with Loftware. which
requires headers in cells A1 and B1. I have formulas in A2 and B2
Though i am not sure but try this Change A2 to A3 in below line
Range(A2).Select in the macro
Sub close_sheet()
'
' close_sheet Macro
'
'
Range(A3).Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.ClearContents
Thanks Chaya.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Fri, Apr 12, 2013 at 12:55 PM,
Hi Chaya,
Please can you explane it that u use in your sheet.
=REPLACE(GET.WORKBOOK(1),1,FIND(],GET.WORKBOOK(1)),)
Regards,
Priti verma
On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Thanks Chaya.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Hi chaya
actually i am not getting Get.workbook
how you use Get.workbook have you written any code for that or it is a
function in other version of excel
On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Thanks Chaya.
Regards,
Kuldeep Singh
Info Edge India
Hi chaya
Thanks to provided me this pfa of noorain sir.
Thanks
Priti verma
On Thu, Apr 25, 2013 at 9:18 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Preety,
PFA Get Function by Noorain Sir. I hope it will help you.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Thank you for the tip. Moving to cell A3 works, except when my only data
is in C3 D3. My goal is to reset the worksheet without the users losing
the formulas.
On Wednesday, April 24, 2013 8:10:58 PM UTC-4, David H wrote:
I am using an excel spreadsheet in conjunction with Loftware. which
try this
Sub reset()
Dim Lrow As Long
lastrow = Range(C Rows.Count).End(xlUp).Row
Range(a3:d lastrow).Clear
Range(c2:d2).Clear
End Sub
Sub applyformula()
Dim Lrow As Long
lastrow = Range(C Rows.Count).End(xlUp).Row
Range(A2:B lastrow).FillDown
End Sub
On Fri, Apr 26, 2013 at 7:11
Click the link below for full tutorial.
http://rajexcel.blogspot.com/2013/01/animate-excel-chart-in-powerpoint.html#.UXoAQKJTCiw
you can find the how to
1-Create Separate Animations Within the PowerPoint Chart
2-Focus on Different Parts of the PowerPoint Chart
3-Open the PowerPoint
Respected Chaya,
There is also an add-in called Ultimate add-in,Which has features like
sort sheets and a lot of very useful features.It is available for 2007 and
earlier excel version also.Please find the attachment and install the
add-in.
Regards,
Vijaykumar
Dear Vijay sir and All experts,
Thank you so much for sharing the Addin. Thank you all for guiding
and helping me in learning excel with VBA.
Regards,
Chaya
On Fri, Apr 26, 2013 at 10:52 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Chaya,
There is also an add-in
12 matches
Mail list logo