Recent Activities

I have worked out how to double click on a range in a worksheet to strike through the value, is there a way i can also double click the same range to un-strikethrough ? I have tried playing about with very basic IF statements but cant seem to figure it…

Hello,

Your question reminded me of a very nice solution proposed a while ago by Andy Pope:

https://andypope.info/vba/colourdropdown.htm

Hope this will help

Hello and Welcome to the Forum

Maybe you could test the following standard instruction
(Code, 1 line)


Hope this will help

My apology, my mistake, I wanted to say further, the final part of all this would be to export, info after all calculations done, a .csv file into our financial system.

Hi Roy, if I can explain a bit.

I had to take out most of the info from the master sheet. The weekly .xlsb sheet contains info pulled from biometric system, which currently is not able to be incorporated into (let's call it for this purpose, "financial &…

Glad you could fix your problem

Whenever possible, please attach a sample file to make everything a lot easier to grasp ...

Hello,

Maybe the attached file could help ...

Attach an example workbook

Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure…

What is this ?

Open_File

You need to attach an example file

I'm not sure what that error is.

I've looked at the workbook that you have uploaded and I cannot see how VLOOKUP can work with that data.

Pleased to help.

Post back if you need further help.

Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.

You cannot colour a ListBox by individual rows.

Your code seems to copying 3 columns of data. It would be more efficient if the headers matched and the code moved the block of data, instead of column by column

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

This pops up after I copy data from one sheet to another using a VBA sub. The sheet contains named ranges with a worksheet scope so I don't know why that would be causing this error. If I click one of the cells with the #NAME? error and drag the formula…

Helloo, anyone out there that can help please?

This is driving me insane. I cannot figure out why this doesn't continue running. Once it's run it will open the file and then stop. It will only run again if I put a break right before opening the file and hit F8 to get it through, then I can let it…

Yeah, that's exactly what I was looking for.....
Thanks