Jan 22 2020 12:25 AM
Hello y'all,
I currently have 2 tables with data, and I'm looking for a macro that can switch the two and remove a specific value.
I currently have the macro:
Dim container As Double
container = Range("B3").Value
Range("B3").Value = Range("G3").Value
Range("G3").Value = container
to switch the two cells, but this has it's problems. I need to make one of these for every cell i switch and when one of the cells is empty, it becomes a 0. On a larger scale, this becomes a lot of work and with it being 0's it doesn't like it in other formulas.
IF anybody knows a easier way to switch them, or even just to make all 0's in to "" that would be great.
Jan 22 2020 02:11 AM
Jan 23 2020 02:36 AM
SolutionThank you for taking your time to help me.
Although I have found a solution already which is more compact.
Jan 23 2020 02:36 AM
SolutionThank you for taking your time to help me.
Although I have found a solution already which is more compact.