Here's a doozy for you.
I have 2 workbooks, one an inventory overview of kit, the other a detailed version. Obviously some info is duplicated. I've made a straight forward link (see below), but it needs improvement,
What I want to achieve:
In the detailed inventory, I type in a row...
I have data listed in a worksheet that contains text in the first column that needs to be replaced throughout the entire workbook.
The data looks similar to this:
Sun, $D$8#Home, $B$42#WWB, $B$3#Definitions
Earth, $D$18#Summary, $B$3#Page 1, $B$42#Classroom
Ball, $E$27#Home, $B$4#WWB...
I have a sheet with over 50 graphs in (to be clear the graphs are in the sheet not the workbook). What l am looking to do is to find a way in VB to locate where in the sheet a particular graph is located based on the graphs name.
Ideally returning a cell reference, but otherwise just a...
I was hoping someone could explain to me the Cells property. I am teaching vba programing from a book to design a ss to work how we need it, but I am having trouble understanding this property. Specifically when using Cells(Rowindex, Columnindex) and Cells(CellPosition) and how it...
Good Day to all. I have been out of excel for close to year now (imagine that) and althought I was never a super user, I have always managed (with help from the pros on this site) to get things done.
I need help once again.
In a worksheet I have a drop down list box that reads from range...