Thanks for your input but that does not solve the problem. By removing the "On error" line it produces the error message. I need the activecell.offs et to move down the list of client ID references.
Excel seems to randomly decide when to be unable to copy/move the worksheet from one workbook another (template).
Still require help if anybody has an idea?
MAdcock
Last Activity: May 1 '08, 11:36 AM
Joined: Nov 13 '06
Location: London
-
Copying Worksheet to another Workbook - ERROR
Hi,
I have created an excel program which creates 65 or more (nneds to be unlimited) customised letters for clients. The macro uses VLOOKUP to change the details within the letter and copies / moves the work sheet to another "template file" which contains printing macros etc. Each new worksheet is subsequently renamed to the Client ID reference.
The program is meant to do all applicable clients letters and... -
Filter
Hi,
I have a spreadsheet with a large amount of data on sheet2 with the autofilter feature enabled. I would like to "pull" these autofilters through to sheet1 so that I may create a control / query feature. Is it possible to "pull" these filters through to another sheet?
If so, how is it done please?
Many thanks
Mark -
Merged Cells - Paste
Hi,
I have written some code to create a copy workbook of another sheet in a workbook, but the outcome is that the copy has links (='[Original.xls]Sheet1'!A5) for example instead of the values contained within the original workbook.
Also there are merged cells which seem to make my macro fall over - Runtime error '1004': This operation requires merged cells to be identically sized.
I don't understand this... -
Excel VB Code - Formula Reference Cell
I have been having major problems trying to write a piece of code to basically tally (add) values in a table (column B) that have the same product name (column A). The problem is that the table is variable (produced from another macro) and so this needs to be taken into account.
To solve the problem it could be performed through using the product name to know which values to add OR as I have already got another column(E) that has a... -
Thanks for that, I do that already and yes the problem is that the macro then references the cells rather than the "LIST" I am after.
If anyone knows the answer - PLEASE PLEASE HELPLeave a comment:
-
Excel list defined via:
Insert - Name - Define
Just to make sure :)Leave a comment:
-
Yes, sorry I forgot to mention it is for an excel spreadsheet.
Help is much appreciated!Leave a comment:
-
Validation List - VB Reference
Hi,
I am struggling with most probably a straight forward problem, but here goes. I want to write some VB coding to match cell values to a list I have already made "Stock" so that only rows with the values as defined in my list remain. My problem is being able to reference the list "Stock" in VB - is it possible to do so rather than retyping the list seperated by commas?
Please could someone help... -
Paste Special - Keep formatted cells
I have created a VB code to export data from one worksheet to another, with rows deleted depending upon the value of a cell. My problem is that when this is copied and pasted to the new worksheet, the formatting (particularly the varying currencies) revert to either plain numbers of GBP.
Does anyone know of the correct code to force VB to keep the format of the cells, be it USD, JPY etc?
Help is much appreciated -
I have tried your code, but it results in the same problem, that my Excel freezes and I have to restart the application.
All I want is for the lines in the spreadsheet with Distribution, Sale, Purchase in column B to be deleted. Is anyone able to write a quick piece of code that will do this process? Ive tried till im blue!
The ActiveCell.Offs et statement was to move the curosr down to the next line.
...Leave a comment:
-
Code is as follows (so far):
Sub GetCache()
Sheets("Purchas esSales").Selec t
Range("A:K").Se lect
Selection.Copy
Sheets("Cache") .Select
Range("A1").Sel ect
Selection.Paste Special Paste:=xlPasteV alues, Operation:=xlNo ne, SkipBlanks _
:=False, Transpose:=Fals e
Sheets("Cache") .Select...Leave a comment:
-
Simple VB Loop
I am trying to create a do loop that will delete rows when the value in a column is 'Sale' or 'Distribution' and I need it to run until it reaches the bottom of the spreadsheet (incorporating blank cells along the way). Once this is complete, the data then needs to be output into a need tab.
I have tried and tried, but excel just freezes. It might be my coding (probably). I know this is minor, but help is needed quickly.
...
No activity results to display
Leave a comment: