error #424

Hi, The code below allows me to add zeros to a specific row. I am trying to change the code to reference a particular cell value where I specify the range I want to use, but I am getting the Object Required 424 Error. I have added both lines of code the one that works well and the one that...

Hi people, I've written a code (alot of help from here, thanks fellas and lasses) that does many things. Essentially it loops through each worksheets starting with MW, in these sheets, it deletes some columns, does some operations and changes some column names. Right now, The code works, but...

Hi people, I'm currently writing some code that I want to do many things, but one of them is to loop through the cells A1 to J1 while checking the value, if it is equivalent to some set values, it deletes the entire column. Right now, the code "works" but it stops and gives me an error 424...

Hi, I have a file that contains two columns: A - file path and B - Title. To select a file, I double click in column A (let's say, A14), which opens an Explorer window. I make my selection and the path of the selected file is inserted in the double clicked cell. Now, to get the title of said...

Hello Everyone, I cant seem to find what is cauing my error.. I s a simpl code to on a file in the foldercopy a column ofdata nd pase in thedestination file on the next open column. Can someone help, maybe Ijus need more sleep, becaue I antsee it. Sub LoopThroughDirectory() Dim MyFile As...