cl.value

  1. P

    VBA Run time Error "424

    I am having a problem with the VBA code below it works fine with Fileout.Write "This is a test" but files when Fileout.Write Cl.Value, Fldr & "" Also it seems to be overwriting the same line so I think a new line command somewhere. Also os it posible to get the code to append to the list...
  2. W

    Help with Parsing Sheets

    The code below is gathering all instances of the same name and creating ne ws with them. but it always creates one extra sheet. How can I get this tonot bake the last sheet? Set ws = Sheets(awsn) If ws.AutoFilterMode Then ws.AutoFilterMode = False With...
  3. D

    updating a macro code

    Hiya and happy new year. I recieved excellent help with my macro code last year, and i have dissected the code to see if i could not learn how it works and to an extent i have managed to :) However, I am struggeling to add inn new code into the existing one. I want to add inn bold font for the...
  4. S

    sheets to PDF

    Hi there, I have a VBA code to split sheets, but now I want to save them as PDF. And there for I have a code but do not know how to add to the code to the VBA code. Can some help, I'm lost..... Split code: Private Sub CommandButton1_Click() Dim Cl As Range Dim ws As Worksheet Dim Ky As...
  5. D

    Macro bugging when using declared variable "Cl.value" to find worksheet name

    Hi Can anyone tell me how to stop the code below bugging at the Sheets(Cl.Value).Activate The filename when I hover over CL.Value is 5837, and this does exist in the worksheet, I have tested by entering "5837" rather than Cl.value and the code runs fine! Any help much appreciated. Sub...
  6. J

    VBA - for each clear cell

    Get a debug in the clear property Sub RCInclude2() Dim Cl As Range For Each Cl In Range("J2", Range("J" & Rows.Count).End(xlUp)) If InStr(1, Cl.Value, "Include", 1) > 0 Then Cl.Offset(, -2).Value.Clear end if end sub
  7. G

    Add TExt to a Cell With a Number

    For Each cl In Range("G7", Range("G" & Rows.Count).End(xlUp)) If cl.Value <> Null Then cl.Value = "ABCD " & Range("F") End If Next cl Hello All, I'm attempting to add the letters ABCD to each cell in column G, starting at G7, with the number in column F Example: F7=2567, then G7 would =...
  8. L

    Sum of Offset Values

    Hi, I have this formula, but i would like to just have in "K" the sum of offset(0,3)+offset(0,4) is it possible on VBA or should i add up that on the sheet and just copy it? Rw = 11 With Sheets("Draft") For Each Cl In .Range("K7", .Range("K" & Rows.Count).End(xlUp)) If Cl.Value =...
  9. muhammad susanto

    VBA : Macro Button Not Work in 1 Sheet

    hello all.... i'm looking for macro code to combine 3 button that works in 1 sheet.. here this code : Sub Insert_Foto() Dim pic As Shape Dim picSource As Worksheet Dim cellFrames As Variant Dim index As Long Set picSource = Worksheets("SHeet1") index = 1 For...
  10. sharky12345

    Update range for each selected item in Multi Select Listbox

    I need to update a column for each item selected in a Multi Select Listbox on a Userform. I'm using this to load the Listbox; With Sheet5 Dim Cl As Range Dim Lst As String For Each Cl In Range("A2:A42") If Cl <> "" And Cl.Offset(, 2).Value > 1 Then If Lst = "" Then Lst = Cl.Value Else Lst =...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top