c.value

The following code adds a new item to a list but changes the structure of the list. The current list is (1 - John, 2 - Mary, 3 - Frank and so on, till 200. If I add an item to the list, the code sorts my list by all the 1's and then all the 2's and so on. I want to add 201 - Jim and have him at...

Good morning all, New member here. My job involves cleansing a data set before it's provided to a client. The data is pulled from our system through SQL report, into a spreadsheet. I've kind of fallen into this role: I'm a lawyer, but someone needs to do this to keep the client happy, and I'm...

Hi, I'm trying to Trim visible cells after a filter is applied. It all works except for the result. Current Cell Value: "11 05 18 09:06:50: closed by linker #MIT # Updates were made well before SLA expired" Result Required Cell Value: "#MIT # Updates were made well before SLA expired"...

Hi everyone, I have been working with this basic macro the last few days, and you guys have been amazing. I just have one last question on this. It will print the first two sheets, but I can't get it to print them Duplex. I tried adjusting the page settings and printer setting, but this...

Hi everyone, I am having some issues with this marco, and full disclosure, I don't know much about macro's at all. But i am getting a runtime 424 error whenever i try to run this. The purpose is to pull from a list of employee numbers and print them on a safety inpection sheet. Any help is...

I have a series of patterns that I am searching for in a cell. For each pattern I find in the cell, I want to parse the matching string and write it to a new row in a new worksheet, along with a key value in a separate cell. I am writing a function in a module. I am able to use the like...

I have an Excel makro that looks like this I expected it to format and left align all instances of Streckkod and Återlämningsdatum, but it only works for the forst occurrence. What am I doing wrong? I'm just a copy-paste programmer and this is the second time I have tried to do something with...

Evening Is this a proper way to highlight specific ranges Thanks Sub HighlightIf() Dim c As Range, r As Range, lr As Long, s As Range, q As Range lr = Range("D" & Rows.Count).End(xlUp).Row Set r = Range("D2:E" & lr) For Each c In r If c.Value >...

Hi All Hoping you can help me understand why this is ignoring 0 values when it shouldnt - it is a number and ive tested it If c.Value <> "" And c.Value <> Empty And c.Value <> "Ok" And c.Value <> "Not Ok" Then 'do something Thank You

I have a Combobox on a Userform named ComboUser - It is populated from values in range L12:L50 like this; Dim c As Range ComboUser.Clear With Worksheets("Setup") For Each c In .Range(.Range("L12"), .Range("L" & .Rows.Count).End(xlUp)) If c.Value <> vbNullString Then ComboUser.AddItem c.Value...

Could someone help me revamp this: Dim c As Range For Each c In Range("Table1[Entity Code]") If c.Value = "R" Or c.Value = "T" Then c.EntireRow.Delete End If Next My current test spreadsheet has four rows (all of which should be deleted by this), but it only deletes two of them. I...

For the sake of learning a new technique in VBA, the code below works fine to replace certain numbers with text, but can it be converted into an array construct where it uses Lbound and Ubound? Is there a better method? Sub ReplaceNumbers() Dim c As Range For Each c In Range("A2"...

Hello All, Thanks for your help in advance. I created this macro below which hides/unhides the entire row if value is zero. Everything works fine until the spreadsheet is asked to hide too many rows and then crashes. Is there a work-around here? I am at a loss... Sub...

Hello All, I tried the following, but it is making all fonts black. What is it that I am doing wrong? For Each c In .Range("A5:A170") If c.Value = "Ex" Then c.Offset(, 1).Interior.Color = 192...

Hi Everyone, I want to add that column "A" must = "Active" for the column to not be hidden in this macro that works great. any ideas how I can do this? thanks Tony Heres my macro Sub Hide_Contr() Dim s As Range, c As Range Date1 = ThisWorkbook.Sheets("Date").Range("B2").Value LastRow3...

I had an issue trying to colour format a calendar of events. I initially started with conditional formatting but it seemed that after a certain point the formats were not being obeyed. I then began to wonder if cells had a numeric limit about the number of times they could be addressed. An...

<colgroup><col span="5"><col><col span="3"><col><col span="2"><col><col></colgroup><tbody> 1 301 88 4155 MRPXX123 000 000 TW123-50 277541 23.00 2 301 88 4155 MRPXX220 000 000 TW2200-81 277469 18.40 3 301 88 4155 MRPXX220 000 000 TW2200-81...

Hello, I am currently working on making macros to make my life easier and wondering if you nice people can help me as I have 0 knowledge of this macro stuff and am learning. I am trying to make it so cells with certain values get their values pasted in the cell below it. I think I am on the...

Hi all, I'm frustrated....I made one change to my code and now i'm getting whacky results The line below that is bold, underlined, italicized is the element that I added, and now my clear contents line is going from C7:T27 to C7:AW160 The step thru function doesn't seem to help me. Mac Excel...

hi all I have this code that does not work Sub replace() Range("A1:A100").Select Dim c As Range For Each c In Selection Worksheets("Sheet1").Columns("A").replace _ What:=":", replacement:=".", LookAt:=xlPart If c.Value <> "" Then c.Value = "From " & c.Value Next End...