Add your own cells you want to check in VBA code

[buhaj47]

I have a file with a VBA code that gets data from source files and gets it all into a single master file. The VBA code fragment doing that is:

Please Login or Register  to view this content.

Can I set it up so that I can specify directly in the master file which cells in source files will be checked, i.e. let us take this row:

Please Login or Register  to view this content.

What code to use so that instead of C14, VBA will take data from a cell that I'll specify in E2 in my master file?

[Kaper]

this C14 is just a string, so if in your master file in sheet identified as sh, cell E2 contains just
C14
then your line could read:

Please Login or Register  to view this content.

[StephenR]

If you mean E2 will contain a string representing a cell address such as C14...

Please Login or Register  to view this content.

[Richard Buttrey]

What code to use so that instead of C14, VBA will take data from a cell that I'll specify in E2 in my master file?[/QUOTE]

Hi,
Try

Please Login or Register  to view this content.

Assumes E2 contains an alphanumeric column row string, e.g. A100

[buhaj47]

I didn't manage to get that to work, I've used the below code:

Please Login or Register  to view this content.

I tried to get master file to show in column F data from Sheet1's cells that I specified in master file's cell F2, e.g. F2 in the master file will show B5, and data from that cell in Sheet1 will be presented in the master. With the code above, nothing is shown, but when I clear F2, an error message pops up.

Capture.JPG