invalid reference

Hi - I cant seem to figure out why I am getting this "Compile Error: Invalid or Unqualified Reference" on the bold/italicized/underlined line of code below. Any thoughts???? Specific line: With .Cells(Lrow, "L") Full Code: Sub Consolidate() Dim wb As ThisWorkbook Dim Sh...

Hi there, I am trying to write a formula (could potentially be easier in VBA but haven't tried that route) which will look at a document called PL and compare the value of a cell on a particular sheet within PL to the another cell on a document called P&L...

I've used named ranges to create charts before but lately I seem to be having some trouble with it as i've got a couple named ranges (one for each series pretty much) which relate to the proper data but when I put the named ranges into the chart, I get the error message "A formula in this...

Hello, people. I have the following macro, which is assigned to ctrl+shift+h to allow users to make a list and to insert hyperlinks to other sheets that have more details than the list can show: Sub linker() Dim strDocument As String Dim strSheet As String Dim strAddress As String Dim strLink...