naming

Hello all! I have some VBA that is creating a pipe delimited text file, but I am struggling to get the name correct. I have managed to save it in the same location, but attempting to name it the same as the excel file has failed. Any help would be greatly appreciated. Sub PipeDelimited()...

I am trying to utlize the recording feature to learn about the code that controls excel via taking an action and then reviewing the code that is recorded. Recently I was able to get the following code to work: Sheets("GEN INCENTIVE").Select Range("AV1").Select Columns("AV:AV").Select...

I want to take the original naming in the image below and turn it into the required naming format. This includes substituting "/" with "-" and then adding a leading zero to sequence number at the end of the number. Using the 1st column, I used a simple Substitute formula to change the "/" to a...

I have a table with two data columns: the first column contains naming values, the second column contains values from 0 to 1, the third - values from 1.000 to 100.000. I want to display them on the same (bar) graph. I've seen such graphs, where on the X axis are naming values (from column A)...

Hi please can you help me, I have the code below where combobox2 is working fine, butwith combobox1 I want the range to be B1, C1, D1, E1, F1, G1, H1, J1, K1, L1,M1, N1, O1, P1, Q1, R1, please can you help? With ThisWorkbook.Sheets("Data") ComboBox1.RowSource = "" ComboBox1.List =...

I have the following code that looks at AC1 and renames the tabs in the entire workbook based on the cell value and if there is no name or any unacceptable characters it gives an error message. I want this to happen only for the active sheet and not to loop through each sheet. I know it is just...

Hi all, Wondering if there is a standard/recommended approach to naming - Ranges - Tables - Graphs - Worksheets - Workbooks etc I've seen table with 'f' and 'dim' before the table name. Just looking for the better way to go about it. Thank you

Hello, I am trying to make naming my files easier. I have a spreadsheet where I have. FILE NUMBER PROJECT NAME My boss likes to use the naming convention of: 0001_TPR_PROJECT NAME [TPR being the company name] I am trying to use =CONCATENATE(TEXT(A1,"0000_TPR_"), B1) but because I...

Hi I have nested if() i.e. =if(cond1, "a", if(cond2,"b",if(cond3,"c",f))) I want to know if I can name that function to for example XYZ and use that name to pass it to another function instead of passing the whole function. Similar idea of naming a range A1:A20 as ABC and then use it as...

Hello , I have this challenge here: I am using this code to add on my userform then I got into a big trap and I need help to get out. Now the textboxes I am adding are all not having the same naming as the “Rw”. One is Rw10 and the other is Reg10. I wish I can change them all to have the same...

The code pasted below is resulting in a table name that starts with an underscore, and I can't understand why - any help would be appreciated. ActiveSheet.ListObjects.Add(xlSrcRange, Range([A1].End(xlDown), [A1].End(xlToRight)), , xlYes).Name = _ Month(pmtDate) & "_" & Year(pmtDate) &...

So I think I need an if statement but I cannot seem to make it work but here is my problem (hopefully I can explain it well enough) Colum A is a number (meters squared of work completed) Colum B is size of rock used (naming convention used through drop down box being used a total of 5...

I am using excel to help me track server information and I nee help with something. We are going to start using a new naming standard and I use the If and Mid and VLOOKUP statements not to look for a certain character in a cell to see if a system is production or non-production. The new naming...

Hi All, I have a workbook which has 16 tabs in it (and potentially more) which are quotes for indivdual clients. What i want to do is have a macro which saves each tab as a pdf under the naming convention "Quote" Then the tab name, then cell D2, then cell D4. This would need to be saved in a...

Hello! I'm new in the wondrous world of VBA-coding and macros, and could use a few tips on how to proceed :) My goal is to make a macro to create a new table with my setting preferences, and giving it a unique name. My problem occurs, when I'm using my recorded macro on another set of data...

Hi all, I'm fairly new to VBA and trying to write some basic macros to reduce some drudgery when working with a few of our standard spreadsheets. As part of this I'm trying to create a new sheet which needs to be named based on data in 2 separate cells. The code is pretty basis but I can see...

This one is starting to hurt my brain. I have a workbook with multiple sheets and the point of the book as a template for a questioner/form. Each tab has various items to fill out or answer. Some basic info, some with dropdowns, and some referenced via formulas. Each client will have their own...

Hi all. Been at this for 5 hours....I can't find a way to name all my worksheets, then make a variable that would select them all. Speed and cleanliness in the code is very important to me, so any optimal or much better ways would be very appreciated. Here's my code: Sub meow() Dim count As...

Hello, I need help with the following stuff: I have named some sells in my worksheet, eg. A1 is named Coupon, A2 is named maturity etc. Now I need an excel or VBA based function that looks at the value of a given cells and then connects that value with the content of a corresponding named...

Can this be done? Is it possible to name a comparative operator such as ">=2" and use it as part of an array formula? I have tried syntax after syntax and nothing seems to work.