Q,

Use vbTab or Chr(9) .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Q" wrote in message
...
does anyone know the code for tab (i.e. like i'm going to
indent a paragraph), i'm tryin to duplicate the keyboard
function.

like vbCrLf is to Enter
as ???? is to Tab

if anyone could help me that would be great. thanks in
advance!

~Q