| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Ref.
Sheets("Test").Range("A1").Value
"Neil Pearce" wrote: Dear all, This is a very basic question but one I know not the answer to... I am working a spreadsheet created by A.N.Other and it has some Macros. One of which does not work. It starts... If Len(Range("A1").Value) + Len(Range("B1").Value) 0 And _ The cells A1 & B1 are actually on another worksheet to the button that the macro is attached. What would I have to insert to enable the code to make reference to A1 & B1 on a worksheet entitled say, "Test"? Thanking you. Kind regards, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming | |||
![Stefano[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
