I drove to work and transmission was working good, when I was leaving I felt the trans slipping and got worst as I drove. I was able to make home but now when you put in any position its like neutral. No code being pulled from computer.

 

V-6 or 4-cyl?
How long since the ATF was changed? How dirty was it? Is the ATF level OK now?

 

I bought honda about a year ago it has about 200K miles on it, trans fuild was about 1/2 quart low, looks like it need to be changed. Is it worth changing fuild or buy a rebuilt trans 2.2 4 cycinder.
what else could I check?

 

Dirty fluid, smells burnt? I guess I would change it 3x (drive around in between). That's an attempt to avoid replacing the trans.

The torque converter doesn't drain, so when you drain/fill you can only get about 1/3 of the total fluid.

I'm a manual-trans guy, but everyone says the auto trans is pretty good up until 1998. Hope others will chime in, but it seems likely you can go with fluid changes. If it was 1998-2002 then I'd worry about the transmission failing.