It wouldn't be too hard, go use a tool like
Morgh's Editor to edit your mod's text files. Usually, I wouldn't recommend it to people, but since you're just looking to tweak around some units I'd say it'd be pretty handy.
From there, you can either:
A. Change all ranged units
or
B. Delete all ranged units
If you have any questions, let us know.