Search results

Hi, Chanduraj! In the last image you can see that the file "Brazil.txt" isn't of file type text but a RET file (https://fileinfo.com/extension/ret) of Business Objects from SAP, so I presume that the full file name is "C:\Brazil.txt.ret". Why? Windows OS installations set hiding filename...

Hi, Andrew Quirl! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards

Hi, Khalil Lakhani! Dates in column I are text, even the custom format is specified as mm/dd/yyyy (that only applies to numeric/date data). So you have to either press F2 in each cell and then Enter, hence transforming from text to date, and then use whatever function you want, or you have to...

Hi, Andrew Quirl! I can't image how to do it, except that in all your workbooks you have: a) same worksheet names b) same relative index position worksheets (2nd and 1st, 5th and 11th... but same on all Regards!

Hi, Frank M! When posting code please do it between the proper tags "["Code"]" and "["/Code"]" (unquoted), also found in the response toolbar, 5th icon from the right. Thank you. Regards!

Hi, Katybug1964! Give a look at the uploaded file. It has the following changes compared to the posted by you. WS Matter List: - added a named range for the data area (i.e., excluding row 1) - added a last column for retrieving data from Engagement: retrieves col E (Y/N), or dashes if not...

Hi, Andrew Quirl! Two different ways to do the job. Regards!

Hi, Andrew Quirl! So the index out of range error that you get is due to the names of your worksheets. IOOR means in this case that no "Sheet2" worksheet was found (like neither in the original version with "Hoja2"); same for "Sheet1". You have to replace your actual "Sheet2" and "Sheet1"...

Hi, Andrew Quirl! First of all, do you have 2 worksheets named "Sheet1" and "Sheet2" (unquoted) in the workbook were you placed the VBA code? Second, where did you place the code? Third, that workbook was the only one opened in that Excel instance? If more than one, which one was selected? Regards!

Hi, Andrew Quirl! You're right. I use Spanish versions of Excel, so sheet becomes hoja. Regards!

Hi, Eloise T! If you change that to mm/dd/yyyy you shouldn't need my code. But, I always recommend to explicitly format date and number columns, to avoid this issues. If in your computer looks fine, you don't know how will it look when you send the file to another person. Displaying no. of...

Hi, Chanduraj! Welcome to Chandoo forums! Checked this yet? http://chandoo.org/forum/forums/new-users-please-start-here.14/ About your question, have you searched in this site for similar problems? I think that this topic has been treated many times. Despite of this, if you use the built-in...

Hi, preethi3290! What do you mean by middle? Could you please elaborate? Regards!

Hi, Andrew Quirl! Not tested, just written here, but hope to not make mistakes. Option Explicit Sub Macro1() Sheets("Hoja2").Select Range("H2").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy Sheets("Hoja1").Select Range("F2").Select...

Hi, Eloise T! I totally agree! That's why I'd like to relieve Belleke now from wondering what to do with those dirty notes in that moment! ;) Regards!

Hi, Eloise T! I absolutely agree with this: But believe me that in your case danger comes tied with a bit of common sense, so it could be worse. Now this is weird: Moving from an Excel version to another one doesn't produce those changes. Excel store date & time as numbers, integer part for...

Hi, Nagin! If you create an userform, you can put as many lines as you want, but you'll have to provide the code for loading them from their storage (worksheet, range) into userform controls, and then the inverse process, from controls to cells range. Regards!

Hi, Belleke! Excel in German but you in Siberia? And they look like this. Regards!

Hi, Belleke! Regarding your signature "When the Last Tree Is Cut Down, the Last Fish Eaten, and the Last Stream Poisoned, You Will Realize That You Cannot Eat Money."... I was wondering... since there're still uncut trees, fishes in lakes and oceans, potable natural water sources... if you're...

Hi, Eloise T! More sure than I can't learn Gaelic... yet! :eek: Regards!

Hi, Eloise T! The printing (? symbol) was just to elucidate how many workbooks you actually had opened. It's nothing required for running any macro. Another way of knowing how many workbooks opened do you have (more technically speaking, with or without VBA code) is to read the left pane...

Hi, Belleke! Spanish version here. Regards!

Hi, Eloise T! Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted. Regards!

Hi, Eloise T! At the immediate pane window (from Excel, Alt-F11, Ctrl-G, Immediate) type this and press enter: ?workbooks.Count It will display below that line the number of opened workbooks. Despite of this, sometimes Excel keeps the VBA project of recently closed workbooks. Regards!

Hi, Eloise T! Am I wrong or you just asked for working on column G, didn't mention anything about multiple sheets and also said that YOU were going to add it to some other code? It just prints the row number that is being processed, only for testing and debugging purposes. I omitted to delete...