Hello All -
I am in need of help (as usual) with some VBA coding. I couldn't find a good example to help me so here I am.
1) I am working on sheet 3 cell E3 and I need to grab a value from sheet 1, whose name will be changing all the time. The value that I am trying to grab is in cell B2.
2) I need to do vlookups on sheet 3, while looking in a completely different file. Let's say C/My Document/Dummy_File and the information is contained on sheet 1 A1:R50.
3) Lastly I need to put text into certain cells but I believe I know how to do this, please correct if I am wrong.
Range("A1").select
ActiveCell.value = "Hello"
with select.font
.name = "Arial"
.size = 16
.bold = true
end with
I am in need of help (as usual) with some VBA coding. I couldn't find a good example to help me so here I am.
1) I am working on sheet 3 cell E3 and I need to grab a value from sheet 1, whose name will be changing all the time. The value that I am trying to grab is in cell B2.
2) I need to do vlookups on sheet 3, while looking in a completely different file. Let's say C/My Document/Dummy_File and the information is contained on sheet 1 A1:R50.
3) Lastly I need to put text into certain cells but I believe I know how to do this, please correct if I am wrong.
Range("A1").select
ActiveCell.value = "Hello"
with select.font
.name = "Arial"
.size = 16
.bold = true
end with