weelilin
10-28-2008, 05:36 AM
Hi i am new here and also new to vba(just started to learn a few days ago).
i am using excel 2003 and vba.I have an excel spreadsheet name generating new exchnage rate.xls.
I am trying to figure out how to extra certain cells ( example : b4 to b50 and e4 to e50) and also adding in the title into each respective cells ( example : under b4 to b50 the title will be currency )and save it into a new excel sheet.
I already got the new excel sheet up.The thing i am stuck with is the cells and title part.Any help would be greatly appreciate.My codes are as below.Thanks =D.: pray2:
I have attatched my codes below.
i am using excel 2003 and vba.I have an excel spreadsheet name generating new exchnage rate.xls.
I am trying to figure out how to extra certain cells ( example : b4 to b50 and e4 to e50) and also adding in the title into each respective cells ( example : under b4 to b50 the title will be currency )and save it into a new excel sheet.
I already got the new excel sheet up.The thing i am stuck with is the cells and title part.Any help would be greatly appreciate.My codes are as below.Thanks =D.: pray2:
I have attatched my codes below.