need macro to output quatation mark...

  • Thread starter Thread starter cdde
  • Start date Start date
C

cdde

seems like a simple thing to do but I need a macro to output some actua
VBA code to an excel spread sheet....everything is going fine....but
dont know how to make is output a quatation mark.

an example of what I want but then....is not the right code is:

ActiveCell.value = "With ActiveSheet.Range("a:a")"

but it gives me an expected end of code error at the first "a"

I also have another cell which has the same problem but it has
varible in it.

example:

Activecell.value = "Set FoundCell = .Find(what:=" & AktiveCell & ", _

but of course i need quotes around the varible....please help!!

seems easy.....i just don't know what to do....

/Craig Hanse
 
I guess you are looking for this:

ActiveCell.Value = "With ActiveSheet.Range(""a:a"")"

Regards,
KL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where am I going wrong? (losing the variable because of need for quotation marks) 3
Speed it up? 4
file output 2
Text output 2
HELP!! Macro Deletes Last Interval 4
XLAM for global macros cannot be run 8
Macro output as Text 2
Need help-For loop 3

Back
Top