Hi Friends, in one of my applicaiton in the office i saw variable is used as Variant. lets say dim A as Variant. more than 1 values are stored in it. please see the below.
dim firstrow , lastrow , dummycolumn as double these values (firstrow , lastrow , dummycolumn) are derived by doing something lets say their values are 1 ,10 and 2 respectively. A is defined as below A = range(cells(firstrow,dummycolmn),cells(lastrow,dummycolmn)).value something like this. it gives values from 1st row to10th rows of the 2nd column. which i can see in watch window when i tried this with hardcoded values it doesnt throw any error while debugging but when i see the value for A in watch window it shows some error. (i dot see any values for A). can somebody explain what is this? i feel like this variant is working like array but when i tried the same its not working. please give your thoughts. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
