Preset/Predetermined string length?

[option]

Hey guys,

Is there any way of coding something to be X amount of spaces long without having to insert all of the spaces? For example, I need to insert 400 spaces at the end of a file per an issue with the tool that uses the file. Currently, I'm manually inserting the spaces, but there has to be an easier way! Any ideas?

 

[pbaldy]

Does the Space function (see VBA Help) serve your needs?

 

[option]

as a matter of fact, it does! thanks!!