Search:

Hi
I have a named range that sits in range D1 to H1. My program uses the FIND method to check that a value exists in the named range. When the value exists then I want to return the position within...

Many thanks - that helped a lot

Ah, it's working now. I replaced 'sheet4' with the actual sheet name and now the values is returned. But isn't it better to use the 'internal' name of the sheet in case somebody remains the sheet at...

Hello Yowser

I do pass the 'Thisworkbook' object by reference to the function but when I get an error when the line runs; 9 - subscript out of range. I setup a test to see if the called function...

Thanks for your reply Westconn1

If I am in a function and want to output some values to a table then I need to pass the name of the table + worksheet + column heading into the function so that I...

Many thanks for the hint. Code is now working perfectly.

Hi Forum. Good morning.

I would like to know how best to reference a workbook and a table object from within a called function or procedure. I have the calling procedure within the worksheet...

Fixed it.

I guess it's not possible to use (cells(x,y), cells(a, b) within a range or with the filldown. I just replaced the 2nd CELLS with a resize and the code runs through perfectly.

Hi,

I have a workbook which is running code and it creates a number of new workbooks. Upon creating a workbook, the code will copy some values to the new workbook onto sheet1 I then want to fill...

Sorry to reply late on this. Been away but wanted to loop back to thanks those who posted a reply or comment. The project went away to the burning issue of the day is no longer keeping me awake at...

Hi

I have a workbook that I create from a macro running in another workbook. The macro copies columns to the new (inactive, I guess) workbook into specific columns. So column "A" from the workbook...

Thanks for your reply.

yes, it is code that I would like. There is a 'pot' of data with 50k row and a list of records that I need to check one-by-one to see if the value appears in the 'pot'.

Hi there,

I need to compare 2 sets of data and flag up where there is either a direct match or a close match. For example, I have a name and a city value in each data set;

Data Set 1:
Column A...

Hi

I need to copy a cell value down into all cells in a column where there is a value in column A. So if I enter 'Yes' in cell C2 and there are values in A2 to A300 then I want 'Yes' to be copied...

Superb. Does exactly what I what it to do and very quickly too.

Many thanks.

many thanks. That is almost meeting my needs 100% except I noticed that I could have a single zip code for a user and the program ignore that in the results. For example;

1007 223108
1008 223108...

Hi

I have an Excel workbook with 2 columns (Zip Code and Rep). I want to show the data so that for each rep I can see the range of zip codes. For example.

This is a sample of data;

Zip Rep...

Sorry to come back on this but I have a small issue with the slighly modified code.

I have validation setup on cells in column 6 such that I can only enter a number between 0 and 100. When I...

All working fine now so thanks for the input.

Working code to copy the value of columns C to K onto cell A1 of the newly created workbook is as follows;



...

Hi

I have a routine that copies filtered records from a worksheet into a new workbook. Everything was working fine and then it stopped and I don't see why. Error is '438 0 object doesn't support...

Excellent code. Worked first time and does exactly what I was looking for.

Thanks a lot.

Hi

I have a TABLE range which has 3 columns. Column 1 is called 'Product', Column 2 is called 'Price' and column 3 is called 'Discount'.

I only want a value in one of these cells for each...

Isn't that for calling a form?

Sorry, I should have been clearer in my original post.

I have a sub routine in 'sheet1' called 'InitProduct' and this is a few lines of code that populates a...

Thanks

So the arrows going missing is a feature of the advancedfilter command and is not something I'm doing wrong? If it's the latter then I can work around it somehow in the knowledge I'm using...

Hi

I have a table range called 'picklist' and I want to do an advanced filter. All that works fine but when the code hits the .advancedfilter line then the filter arrows are removed. I could put...

Hi

I have a private sub routine called 'initProductForm' and this does everything I want when called from a click event; initialises listboxes, populates listboxes, sets screen messages to blank,...

Hi

I have some activex command buttons and listboxes on an Excel workbook. Everytime I click the command buttons the text increases in size and just keeps on growing.

The text within the...

All working consistently now. As I have the range as a table range rather than a normal range, I had to use ListObject to get it working.

Thanks

now it works again but I had to fully qualify the worksheet and range on the entirerow.delete command;



With Sheet1.Range("PickList")

.AutoFilter Field:=2,...

sorry to come back on this again but I'm back to getting the 1004 error with the entrirerow.delete statement. Code is unchanged from when it was running with the exception I added the .autofiltermode...

It is strange. I ran that and it showed the range was there. Then I commented out the function call and added some code around what you supplied so that my code now looks like this;



Private...

Hi

The range exists as I'm only deleting a few rows from it. I checked in RANGE MANAGER and can see it listed.

ah, stupid me. Thanks - code tags now corrected.

The following code is set to delete any rows within the range 'picklist' where the value of column B is set to 'No'. This was working fine but now I just get a 'run time error 1004 - delete method of...

Thanks

Sure, I can use that and drop the reference to the RANGE for this particular check. I was just looking to be consistent as I have used ranges everywhere else in the code. Just want to be a...

The range PRODUCT is multiple columns.

The left most column is always the same column heading (BA) but the length (i.e. number of rows) can vary as more rows are added.

I think it is my error that causes this not to work. I have adapted your code to the following so as to incorporate my RANGE rather than relying on the
A65536 cell.

My code:



myRow =...

Hi Forum

I have a workbook with a range called 'picklist' and I want to filter for all rows where the first range column is set to 'Yes'. If any are returned then I want to copy columns C, D, E, F...

Hi

Is it better to use 'resume next' rather than trying to find out the number of records returned? Ideally I would like to have a way to find the number of records in the filtered range as I can...

Thanks a lot for this and for replying to all other post over the last couple of weeks.

Code sample looks good. Thanks. I will give it ago within my project and adjust as needed.