To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
oops. change o1 to p1
Application.DisplayAlerts = True
Columns(f).Copy Range(p1)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Sunday
...@gmail.com
Sent: Tuesday, January 31, 2012 2:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
Dear group,
1. Based on the ideas from Paul, changing code can help me to get desired
results.
If IsEmpty(.Cells(R, E
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
Dear all,
I have composed some code for this, however, there is error happened, can
anyone suggest to solve? Highlight in yellow has problem.
Private Sub CommandButton2_Click()
'Inserting columns and fill
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Darwin Chan
*Sent:* Monday, January 30, 2012 12:11 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2
cells
** **
Dear all,
** **
I have composed some code
oops. change o1 to p1
Application.DisplayAlerts = True
Columns(f).Copy Range(p1)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Sunday, January 29, 2012 11:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Splitting the values from 1 cell to 2
, January 30, 2012 4:25:57 AM
*Subject:* Re: $$Excel-Macros$$ Splitting the values from 1 cell to 2
cells
Hi Asa,
First thank you very much for suggesting why there is an error. As
a newbie in VBA programming, I really dont know much about OPTION EXPLICIT,
only to the extent it requires us
-macros@googlegroups.com
Subject: $$Excel-Macros$$ Splitting the values from 1 cell to 2 cells
Dear group,
I would like to get the value from 1 cell and split the value to 2 cells.
Any VBA formula can help achieve this?
Code starts from Private Sub CommandButton2_Click()
Criteria