lines

Hi All, Using 3 lines of code below i run into error 1004 autofilter method of range class failed on the last line. Range("C12:P12").Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.AutoFill Destination:=Range("C12:P12"), Type:=xlFillWeekdays Could someone please help...

Hi, how can I remove lines within each cell (multiple lines with line breaks) that are not starting with a numeric character? <tbody> 223213 - this line needs to stay chair - this line needs to be removed 9 - this line needs to stay needs to be removed </tbody> Thanks and best, Jack

I have a spreadsheet in which I want to lock the formula in 2 of the columns but still be able to add lines to the table. Can I do this?

Hi all, got a quandry here. Let's say I have a table like the below: <tbody> Paper Company Template Flag 1 Aber Chronicle JG UK 2 Aber Chronicle JG UK 3 Ban Guard JG UK Y 4 Ban Guard JG UK Y 5 Biggle Chronicle JG UK Y 6 Biggle Chronicle JG UK Y 7 Biggle Chronicle OM UK 8...

Thanks in advance for any solutions, suggestions or help for which I will give feedback. I have two questions which are similar, but not exactly the same: (1) How do you break a comment such as the following into multiple lines (i.e. continuation)? This is basically so I can keep it on the...

Hi all, I'm looking to replace a legacy system to select adverts from a database which uses some pretty beefy VBA code with a new system that uses criteria to take the information from the same database. My question is whether autofilters are a good idea or if there's an inherent fault with...

Hi, I want to create a procedure where I will pass a userform object and that procedure will give me the all controls name and type related to that form, I have created below procedure but it is not working. When I run procedure "Test2", in the line "Set myForm = FundInfoForm" it is firing the...

I have a spreadsheet with 115 lines of 10 units of data on each line. 5 different numbers and 5 different letters on each line. I m trying to find out how I write a macro to show me the matched pairs and matched triples on this spreadsheet. My other question is how do I count all the numbers of...

Hi everyone, first up - apologies for the very beginner level question, I have never learnt VBA and don't use it much, so I typically just play around until I get it to do what I want. No hate! I am looking to cut down my code a little on 4 lines that I use quite a lot, which is basically...

Hi, I am wondering how to do this background in excel. Grid lines are not showing and the focus is just on the worksheet https://www.dropbox.com/s/5jd8kus6f3p21hh/Product-Selector.xlsx?dl=0

Hi, I am grabbing the .Value from a variable. How to copy formatting of cell above as well? Shortest code possible as I have many lines of code like this. wsSheet2.Cells(3,2).Value = TestSheet1 Thanks in advance.

so..... this seems to be pretty straightforward but for the life of me i can't seem to think of a formula that could work with this.... i have a list of salesmen who well.... made sales... and i need to count the amount of sales per salesman, however, the salesman nema only shows up once per...

Hello all. First post... Here is a simplified example of what I want to accomplish. I can change the individual's mobile data rate plan for my group each month, depending on usage. I have ~1000 lines to work with. The plans are only grouped for readability. Rate plans are: 01. 1 MB Plan -...

Hi, I have a table of data, it is a list of actions for different team members, so the columns are: A1 = action number, A2 = name of the team member, A3 the Action assigned. I want to have 1 central database of actions with all of the teams work related actions on, this is the main source, BUT...

Hi all, hopefully a simple one. I have a sheet of data that is updated on a regular basis. Therefore at the moment lines 2-55 are populated, but lines 56-700 are not yet (but will be over time) I want to create a 'dashboard' tab which displays charts based on data on my first tab, but want it...

Good morning! I have a data set that comprises one record per row in excel, however the cells in columns M and N may be one line of data, or may grow into several lines of data. For the rows that have multiple lines of data in cells M and N I have been manually going in and adding blank rows...

Hi, I use Excel to create journals that I then upload the problem with this is that it creates additional commas on some lines that I then have to manually remove, is there any VBA I can use that saves the sheet as csv pops up with the save as dialogue box but removes the excess commas? The...

Hello, I am trying to add directional arrows. I have a data series in my chart that is essentially 2 vertical lines and I want the arrows to point to those lines. Is there anyway to set the position in vba based on that vertical line series? This would have to be something that automatically...

Please, I need a search textbox for this code Private Sub UserForm_Initialize() Dim x As Long, FileNum As Long, TotalFile As String, Lines As Variant FileNum = FreeFile Open "C:\Temp\History.txt" For Binary As #FileNum TotalFile = Space(LOF(FileNum)) Get #FileNum , , TotalFile Close #FileNum...

Don't know why I'm finding this so difficult and search engines don't seem to help. Have spreadsheet with a total for each day. I want a Line Chart where the totals are on the Y-axis and the week numbers are on the X-axis with one line for Monday, one line for Tuesday, etc. Seven lines in all...