Search results for query: *

I have a worksheet that is hidden. Whenever the checkmark is clicked, which would result in F12="TRUE", then I want it to open this other sheet called "Polymerase". However, the sheet is protected w/ a password, and I do not want it to prompt the user w/ the password. I have...

I changed the code, and it gave me a Run-time error '1004'; "could not be found.Check the spelling of the file name, and verify that the file location is correct." on the line "Set wbOne = Workbooks.Open(Filename)" My changed code is as follow: Filename2 =...

I have a macro that manipulates the cells from 2 workbooks. It prompts for 2nd file to be open, do some calculations, and then copy and paste some cells from 2nd opened workbook to the 1st workbook. This procedure worked fine when I run it from the .xls file. However, when I have it as a add-in...

I have an autofill VBA code to fill the cells from a formula. When I run the procedure, it did not autofill. However, when I step through the code, it did autofill each cells. I am not sure why it does not work when I run the procedure, but works when I step through the code one by one. Here is...

Thank you, Loomah! Assigning the workbook to Object variables worked great! Thanks so much! I appreciate it!

I have a workbook open, and then I prompt the user to pick another file to open on a new workbook. From there, I have some procedure to do some manipulation on the new workbook. Then I would like to go back to the 1st workbook and do some more manipulation of the 1st workbook , and then copy...

Thanks so much Zathras! It works great!!! Thank you so much again! I really appreciate it!

Zathras, I retested it again on the sheet and adjusted the data around, and it did scan the next group! The problem was that there are a couple of headings before the 1st group of data w/ blank lines in btwn, so I believe I have to have a Loop to do the scanning and deleting until there are...

Zathras, Thank you so much for your help! I really appreciate it. I ran your code on the file, and it did not seem to scan the entire sheet to delete duplicates in Column B. It seemed to only start at Row 2 only and until it reads the 1st blank, and then it does not seem to read the next...

Zathras, a) Yes, there is always a blank line in btwn the 2 groups. b) The #s in Column A do not always increase within the groups. But the #s for the 2 groups always start with 3 and end with 382 ... some #s may be missing in btwn. c) There would be the miscellaneous rows of data, then a...

Sorry for not being as precise. My data look something like this: A B 1 3 Gadgets 2 4 Gadgets 3 5 Things 4 6 Things 5 7 Items 6 12 Gadgets 7 13 Gadgets ..... 387 3 Gadgets 388 4 Gadgets 389 5 Things 390 6 Things and...

This is something that I would need to do often. I thought of another method that I can determine which cells to sort though. On Column A, I would have cells w/ values ranging from 3 to 382 (w/ some skip #s in btwn). Then there would be some miscellaneous rows of other data, and then another...

Thanks for your reply. Is there a way I can check this w/out sorting Column B first? The reason I do not want to sort it b/c there are some rows that I do not want to sort. Thank you so much!

I would like to loop through Column B, and if I find the same repeating value, then I would like to delete the rows and keep only one. I would always have 4 replicates, but would only like to keep one. For ex., Loop through Column B, and if found "A2" multiple times, then delete 3 out...

Thanks for both of your help! It worked! Thank you!

I am not too familiar w/ looping and searching for text in Excel cells. I would like to look at each cells in Column E, and everytime it sees the word "Standard", delete the whole row. How can I do this? Thank you!

I have the following code which I write teh values from a range in Excel to a txt file. However, it's writes the values back w/ quotes (") around the values. If I add the code : If IsNumeric(vData) then vData = Val(vData), this would get rid of my leading zeros in my values. For ex...

Thanks for your help. However, I prefer not to do "Save as" b/c then this would rename the current file open and cause some confusion. I would like to just export the Columns A & B to a txt file. Is there a way to do this? thanks!

How can I have Excel open a file? For ex, a Word document called "test.doc"? I have the following code to open the Word application successfully, but I basically just want to open the file. Thank you! On Error Resume Next Program = "WINWORD.exe" TaskId =...

How can I export only Column A & B of this worksheet to a txt or .csv file? I have the following code so far, and it is not working: Set ExpRange = Columns("A:B") ExpRange.Select With CSVFile .ExportRange = ActiveCell.RangeSelection .Export...