Hi All,
Need Your help,
I want 2 insert 2 empty rows between 2 rows containing data.
Please suggest how to do it.
Ex. : -
Before
Khata No-127 Plot No-657,658 Mouza -kokpara Ps-dhalbhumgarh East
Singbhum Kursa Katta Plot No-549, Khata No-257, Mouza-badia, P.s.musabani,
Dist-east
Sure, here you go. In the attached sheet, you have N/A displayed in sheets
QF SF. If you want to replace N/A with blank, use the following steps
1. Press Ctrl + F
2. Type N/A in Find What
3. Click on Replace
4. Do not type anything in Replace With
5. Click on Options
6. In the
Hi All,
M new to VBA codes, but i've been using macro using the record
function.
I have created a macro as below...
auto_2 Macro
' Macro recorded 6/25/2009 by Prashant
'
Sheets(Sectoral).Select
Selection.AutoFilter Field:=3, Criteria1:=Auto
Range(A4:B17).Select
Dear Group Members,
I request you to help me in this regard.
*I need a macro, that paste special an already copied text from email /
any other source .. as values in a word file, change its font to Arial,
font size=16 and colour=Blue and save as on desktop with name my diary
dd-mm-.doc*
Hi Terrance,
You can do this without macro.
1. Create copy of Pivot Edit-Move or Copy Sheet.
2. Remove Subtotal and do Pivot Table Copy- Paste Special- Values.
3. Apply Advance Filter and Filter the Data.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Try =proper() command
Regards
Saravanan A R
On Wed, Jun 24, 2009 at 1:40 PM, Subu mail_to_s...@yahoo.com wrote:
Dear List members and XL Gurus
I have an XL sheet with a column that looks something like
Name_One
nAme_two
NAME_THREE
name_four
name_fIVe
name SIX
name sevEN
...and
Hi there,
Thanks so much it works fine now.
Have a good one.
Nourredine
2009/6/25 Upendra Singh upendrasinghsen...@gmail.com
Hi Nourredine,
Do as Below :
1. In the word merged document, right click the merged field for
which you want to change the format.
2. Click
Fabio correctly pointed out the problem. It was caused by my lack of
understanding of relative addressing.
Thanks, Fabio!
On Jun 25, 10:00 pm, Fabio Lemos flnle...@gmail.com wrote:
see the atteched file... I´ve created another column and another names
2009/6/24 Anderson, Jim
Hello Members,
Please submit your tip for this week competition. We have not seen
competition this week.
I would appreciate your active appreciation in the competition.
Click on the link below to submit your tip :
Hi Mahesh,
'Try below code:-
Sub insertt()
Cells(1, 1).Select
While ActiveCell.Offset(1, 0).Value
ActiveCell.Offset(2, 0).Select
Selection.EntireRow.Insert
Selection.EntireRow.Insert
Selection.End(xlDown).Select
Wend
End Sub
'Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91
Asad/Surendra,
MS-Access Book for your reference.
MS_Office_Access_2003_EBook.pdf
http://rapidshare.com/files/248961528/MSPress_Step_By_Step_MS_Office_Access
_2003_EBook.pdf
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
Hi,
Visit our groups site i.e. on google groups and look for files. There are
many files uploaded in our groups section. You'll find one zip file there
named Excel 2007 Macros Made Easy.zip (size 4 mb) Check the file. Its nice.
I am going through it now.
Bye for now,
Prashant.
On Fri, Jun 26,
Dear all,
Hope all are fine,
Please any one explain me how to use ADD watch(when we right click on the
opened excell sheet) how it useful for works,
Advance thanks
--
Thanks Regards
Shivashankar.C.Katageri.
--~--~-~--~~~---~--~~
13 matches
Mail list logo