PDA

View Full Version : extract certain cell value



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.

Bob Phillips
10-28-2008, 05:51 AM
You mean that you don't want the headings? How do you flag where the data starts, and how do you identify the columns to copy?

weelilin
10-28-2008, 06:20 AM
sigh the thing is i am expected to put the title for the respective cells in myself.e.g in my new excel sheet named " Revaluation.xls" i have to extract the exchange rate excel sheet and input a header using codes.It is suppose to follow the format as shown below.I have attatched the excel sheet to show you what i mean.Sigh tat's the tricky part.