There really aren't any limits in size. A full wave dipole for 1Mhz is several miles, while light (which is increadibly short) would require nanotech lengths. The thing is, for those lengths (think upper microwaves) that are mechanically practical you can tweak the antenna electronically with capacitive or inductive reactances, and make its length seem different than it is.
You want some really long wavelengths either google or look up ELF with Wikipedia.