Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. inetquestion

    xml - add/remove/change element contents

    I've got an xml doc which I'm using xslt to create a flat text configuration file. I need to make some dynamic changes in certain circumstances where some of the elements need to have others substituted in their place. Other elements may need to be added or deleted altogether. So far I'm not...
  2. inetquestion

    VBA cannot use Undo/Redo button

    I have a VBA function that does a copy/paste. After its been invoked there is no option to undo those changes other than closing the doc and reopening it. Is there any way around this sort of thing so that you can actually use undo/redo on the toolbar? TIA, -Inet
  3. inetquestion

    VBA copy/paste only if cells are empty

    I have a spreadsheet as shown below. VBA code was inserted so the double clicking on the cells in Colomn A where the months are listed would take the values in ROW1 and copy them to the row you clicked on. What modifications should be made so that this copy/paste would only occur if the...
  4. inetquestion

    excel - create a button to copy data to new rows...

    What would be involved to only perform the copy/paste if the destination cells were all empty? TIA -Inet
  5. inetquestion

    excel - create a button to copy data to new rows...

    Finally figured this one out... Apparently the carrage return after ".copy" is very important. I have no idea why you can't combine this all on one line as in your initial example (which worked) but you can't. :) In any regard thanks for your help; it's very much appreciated! To anyone...
  6. inetquestion

    excel - create a button to copy data to new rows...

    Ok....I'm learning, but still have a few problems. Now I'm trying to get it to only paste the values of (b1:f1) instead of the borders and formatting. I've been looking at the pastespecial function, but have no idea what the heck is going wrong. Destination:=C.Offset(0...
  7. inetquestion

    excel - create a button to copy data to new rows...

    I'm unsure how to do this: Select the default amounts range (in your example B1:F1) and name it "DefaultAmounts". I was assuming you meant insert the value of defaultamounts in cell A1, but this doens't appear to do it. The error I'm getting is: Run-Time error: '1004' Method 'Range' of...
  8. inetquestion

    excel - create a button to copy data to new rows...

    I'm not sure what to call what it is i'm looking for, but can describe the desired result.. I've got an excel spreadsheet with values across the top row, and months down the first column. IE: 0 | 100 250 500 300 4525 -------------------------------------------- Jan| FEB| MAR| APR| MAY|...

Part and Inventory Search

Back
Top