Hi Shannu,
For that u can use =CONCATENATE().
On Tue, Jul 28, 2009 at 10:44 AM, shannu shannu shannur...@yahoo.comwrote:
Hello Dave,
Incase if I have to assemble all the different cell
values like i3, j3,toz3 all these cell data to be assembled in one
particular cell
Hope this solution works for you.
Regards,
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of hemant shah
Sent: Tuesday, July 28, 2009 5:48 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can any one
Not like that,
I want all the cell values to appear in one single cell. like this
eg in cell A10.
name
designation
subject matter expert
company name
contact number
address
All this details to be extracted from diff cells and pasted or copied in one
single cell.
Regards,
Shan
---
ok..
Your FUNCTION is in the XLA file.
You're USING it in the XLS file.
Now, in Excel VBA, Thisworkbook is the excel file the CODE is in.
that is, within the Function (in XLA), ThisWorkbook is the XLA file.
You SHOULD be able to use:
ActiveWorkbook.ActiveSheet
to refer to the XLS file and
Hi,
I don't think this can be done with worksheet functions. You'll have to use VBA.
Something like the following:
Range(A1) = Range(I3) vbNewLine Range(J3) vbNewLine Range(K3)
This puts 3 lines of data into A1.
If you want to put lots of lines of data into one cell, we could use a loop:
A
Attached is password removal tool. You can you it by add-in. These is for
removing password from Sheet.
Regads,
_
With Windows Live, you can organize, edit, and share your photos.
Hi Shannu,
can u attach a sample file.
On Tue, Jul 28, 2009 at 1:44 PM, shannu shannu shannur...@yahoo.com wrote:
Not like that,
I want all the cell values to appear in one single cell. like this
eg in cell A10.
name
designation
subject matter expert
company name
contact number
hi ppl
In one of the cell i have a long string say Yes ABD YES NHU JUI NO TIO
TIO NO JIK JIK YES JAK
The desired output shud b like:
ABD, NHU JUI, JAK
I need 2 write a macro for the same
please help
Thanks Regards
Pinky
--~--~-~--~~~---~--~~
Hi Debasis,
Open a blank excel workbook,
Go to Tools options Calculation click on Automatic and save it at any
location.
It will work
On Mon, Jul 27, 2009 at 12:46 PM, DEBASHIS BANERJEE
debashis@gmail.comwrote:
Dear All ,
I have been facing a problem regarding opening Xls
HI GUYS
THANK U VERY MUCH
RGDS
PINKY
On Jul 28, 1:14 pm, shannu shannu shannur...@yahoo.com wrote:
Not like that,
I want all the cell values to appear in one single cell. like this
eg in cell A10.
name
designation
subject matter expert
company name
contact number
address
Hi All,
Can you pls help me on the attached problem...
Hope to see your response soon
Regards,
Hemant Shah
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1.
Hi Hemant,
I tried to solve ur query and attached excel has solution, may be that can
help you
On Tue, Jul 28, 2009 at 5:48 AM, hemant shah hemanthin...@gmail.com wrote:
Hi All,
I have recently join the group and i have one query on excel.
Please see the attached file for the query.
Hope this what you want.
Saurabh Patel
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of hemant shah
Sent: Tuesday, July 28, 2009 4:13 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help
Hi All,
Can you pls
For password removal
Date: Tue, 28 Jul 2009 18:37:00 +0530
Subject: $$Excel-Macros$$ To Unprotect Sheet
From: s.bhadori...@gmail.com
To: excel-macros@googlegroups.com
Hi All,
I have a excel file, I forget password of a sheet
please help to unprotect this particolar Chart
Hi Dhananjay,
Download the add-in from the files section of this site or from
http://technicana.com/vbaSection/TechnicanaAddin.html.
Then open Excel and go to the menu bar and click on Tools-Add-ins.
The Add-ins dialog box will appear. Click on browse to and find the
TechnicanaUtilities.xla
Hi.
Try :
Sub Parse()
Dim txt As String, Tabl, Teste As Boolean, Sep As String
Tabl = Split(ActiveCell, , )
For Each Item In Tabl
If UCase(Item) = YES Then
Sep =
Teste = True
ElseIf UCase(Item) = NO Then
Sep =
Teste = False
ElseIf Teste = True Then
Hi Harmeet,
It shows that password remover is expired
Shiv Pratap
From: Harmeet Singh harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, July 28, 2009 7:47:09 PM
Subject: $$Excel-Macros$$ Re: To Unprotect Sheet
Use attached Addin
Use Concatenate with
Char(10) ( refers to the alt+enter in cell)
or
=Designation CHAR(10) Name CHAR(10) So on
or
= A2 CHAR(10) B2 CHAR(10) C1 so on
or
= A2 A1 B2 A1 C1 so on (where A1 refers to = Char(10)
whatever applicable.
Set Word Wrap = True from Format Cells. Otherwise you
Dear members,
Please kindly help me with FAQ's on VBA Excel. I am working on excel
so far, now I have a interview with one of the top company on VBA. I
have got little knowledge on macros through our group.
Thanks in advance
Regards
Ramesh
use this code
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66:
Hi Shafiq
Where is the file... Please attach the same
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Tue, Jul 28, 2009 at 3:59 PM, shafiq online shafiq_onl...@hotmail.comwrote:
Attached is password removal tool. You can
Dear Members,
Let us begin week # 31 quiz.
Last Date of Submission of tips : 2nd August 2009
PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE
CONSIDERED FOR PRIZES.
DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS.
You need to submit your name, Subject the details of
Hi,
I have a column in excel with a list of names. I would like to write
in vb for a command button to open the file with the name in the
column i.e. name.csv as part of a loop where values are extracted from
name.csv and put in subsequent columns in the original document then
move on to
Hi,
I am wondering if someone can help me move data from a range
(contiguous data like a table) to another range that has multiple
areas. In short, the destination may have lines with formulas between
each area and I am not always moving the whole row. You can think of
this as a complicated
Hi Shivkumar,
That was amazing. Could you please let me know how did you set
passwords as you showed in the workbook.
Thanks,
Srinivas
On Jul 28, 1:06 pm, N.Shivkumar shiv1...@gmail.com wrote:
Dear friends
I am attaching a file passwords. xls which helps in giving two passwords for
Hi All,
Please find attached the excel sheet with problem statement.
--
Regards,
Ashwani Singh
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
26 matches
Mail list logo
