This code wasn't quite right and it was giving me errors.
I found the problem was in this line: " if date(Range("B2").value)
=dtdate then "
I corrected it to read " if Range("B2").value=dtdate then " and it
works fine!
Many Thanks!
Doug
On May 20, 4:06 am, bala wrote:
> Hi,
>
hello
i downloaded the (abletoextract professional) software for converting pdf to
word , for which excel group provided me a 16 digit pin also, but now after
30 days i want to use this software , its not working, if any can again
provide me that pin no.
Thans in advance
Puneet jain
Power Financ
Hi,
Try this code
dim dtDate as Date
dtDate = Thisworkbook.Names("IDO_Date"").RefersToRange.Value
for i = 2 to Sheets.count
sheets(i).select
if date(Range("B2").value)=dtdate then
Exit For
end if
Next
On May 19, 7:44 pm, Doug wrote:
> Hello,
> I have a work
send the file please
On Tue, May 19, 2009 at 8:14 PM, Doug wrote:
>
> Hello,
> I have a workbook with a separate page for each date. The date is
> always in cell B2. On the first page of the workbook I want to enter
> the date into a cell named "IDO_Date" and click on a button to go to
> the wo
