Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks
I will update the text -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "WingZero" wrote in message ... No, it is fairly clear, I just had my mind somwhere else I suppose. A slightly better wording however, would be: Change the following two lines of code before you run the macro. Each workbook that is selected with GetOpenFilename should contain a sheet name and data range that matches your changes. Note: If the sheet does not exist in a selected workbook, that row will be highlighted in yellow. ShName = "Sheet 1" '<----------Change sheet name Set Rng = Range("A1,D5:E5,Z10") '<----------Change selected cells Thanks again for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open many *.tsv files in folder and import the data into Excel | Excel Programming | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
Import data from multiple excel files | Excel Programming | |||
Excel VBA - Import Data for manipulation from multiple text files | Excel Programming |