Can I have a statement to add information to a cell that already has data.
For example the cell has the following description:

depth = Worksheets("DEFAULTS").Range("C6")

However, when I choose NO in a if condiction (see below) I want to add "_2nd
file" to this specific cell:

ElseIf resp = vbNo Then
'save the file by adding (2nd file)
depth = "" & depth & " " & "__2nd file" & ""

I added as I show above but it is not working.
Could you please help in this matter.

Thanks.
Maperalia

You've updated the string Depth, but you haven't updated the cell yet:

ElseIf resp = vbNo Then
'save the file by adding (2nd file)
depth = depth & " " & "__2nd file"
worksheets("Defaults").range("c6").value = depth
....



maperalia wrote:
>
> Can I have a statement to add information to a cell that already has data.
> For example the cell has the following description:
>
> depth = Worksheets("DEFAULTS").Range("C6")
>
> However, when I choose NO in a if condiction (see below) I want to add "_2nd
> file" to this specific cell:
>
> ElseIf resp = vbNo Then
> 'save the file by adding (2nd file)
> depth = "" & depth & " " & "__2nd file" & ""
>
> I added as I show above but it is not working.
> Could you please help in this matter.
>
> Thanks.
> Maperalia

--

Dave Peterson

Dave;
Thnaks very much. It is working wonderfully.

Maperalia

"Dave Peterson" wrote:

> You've updated the string Depth, but you haven't updated the cell yet:
>
> ElseIf resp = vbNo Then
> 'save the file by adding (2nd file)
> depth = depth & " " & "__2nd file"
> worksheets("Defaults").range("c6").value = depth
> ....
>
>
>
> maperalia wrote:
> >
> > Can I have a statement to add information to a cell that already has data.
> > For example the cell has the following description:
> >
> > depth = Worksheets("DEFAULTS").Range("C6")
> >
> > However, when I choose NO in a if condiction (see below) I want to add "_2nd
> > file" to this specific cell:
> >
> > ElseIf resp = vbNo Then
> > 'save the file by adding (2nd file)
> > depth = "" & depth & " " & "__2nd file" & ""
> >
> > I added as I show above but it is not working.
> > Could you please help in this matter.
> >
> > Thanks.
> > Maperalia
>
> --
>
> Dave Peterson
>

Dave;
Thanks very much. It is working wonderfully.

Maperlia

"Dave Peterson" wrote:

> You've updated the string Depth, but you haven't updated the cell yet:
>
> ElseIf resp = vbNo Then
> 'save the file by adding (2nd file)
> depth = depth & " " & "__2nd file"
> worksheets("Defaults").range("c6").value = depth
> ....
>
>
>
> maperalia wrote:
> >
> > Can I have a statement to add information to a cell that already has data.
> > For example the cell has the following description:
> >
> > depth = Worksheets("DEFAULTS").Range("C6")
> >
> > However, when I choose NO in a if condiction (see below) I want to add "_2nd
> > file" to this specific cell:
> >
> > ElseIf resp = vbNo Then
> > 'save the file by adding (2nd file)
> > depth = "" & depth & " " & "__2nd file" & ""
> >
> > I added as I show above but it is not working.
> > Could you please help in this matter.
> >
> > Thanks.
> > Maperalia
>
> --
>
> Dave Peterson
>