; Result(k, 1) = Data(j - 1, 2)
> k = k + 1
> Next
> End If
> Next
> Sheet3.Range("A5").Resize(k, 2) = Result
> End Sub
>
>
> Rgds,
> [dp]
>
>
> On 21-02-2014 5:10, Rob Flott wrote:
>
>
I am trying to determine the code that would (passively) record the users,
within our company, who are using a selected workbook.
Is this feasible and if so how do I write it.
Thank you,
Rob
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
For whatever reasons the size of my ActiveX ListBox expands and shrinks on
an inconsistent basis forcing me to use the Forms ListBox instead.
The problem I have with the Forms ListBox is the small font.
1. Is there any way to change the font size within the Forms - ListBox?
2. If not, is the
My application allows the user to make a copy of a worksheet so it can be
viewed outside of the application. The problem I have with this is the
code written to that specific worksheet.
Is there code I can include in the 'make copy' macro that would remove all
VB code associated to that sheet
On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant upon
what is selected in ListBox1...it will automatically enter the appropriate
range into the ListFillRange of ListBox3:
Private Sub ListBox1_Click()
With ListBox3
.ListFillRange = Sheets(2).Range("T30")
.S
d this error..
>
> cheers
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Dec 12, 2014 at 1:03 AM, Rob Flott > wrote:
>>
>> On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant
>> upon what is selected
Why does my sheet tab calculate if there are no formulas on the tab, or
even on the workbook?
I am using Excel 2010 and my workbook has 3 tabs; each with about 3400 rows
and about 30 columns of data.
Every time I sort the data, down in the status bar it shows 'Calculating
(4 Processors)' .
I have a workbook with nearly 200 worksheets. Each worksheet is named for
a specific retailer.
Included in this workbook is a sheet listing 75 of these retailers.
I want to create the VB code that opens the sheet with the list of 75
retailers, selects the name and then finds the corresponding s
Mayday MaydayI need help
My workbook contains several sheets displaying various report forms. The
content of each report is based on the selections made from a UserForm.
On the Workbook_Open macro I have 'Call OpenUF1' code to open the UserForm.
Sub OpenUF1()
Load UserForm1
UserFo
Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
names. This range will vary, and I have a Named Cell that identifies the
range. For example the range of names in one example is A3:A8. But in
another example that range could be A3: A21. I would like the ListBox to
l
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote:
>
> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of
> names. This range will vary, and I have a Named Cell that identifies the
> range. For example the range of names in one example is A3
sage?
Thank you for your help with this.
Rob
On Thu, Jan 23, 2014 at 2:21 AM, Anoop K Sharma wrote:
> Hi Rob,
>
> Please have look at attached one...
>
>
> On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote:
>
>>
>>
>> On Wednesday, January 22, 2014 3:36:1
Ricardo,
Thank you very much, I really appreciate your help.
Rob
On Fri, Jan 24, 2014 at 7:15 PM, Ricardo® wrote:
> Hi Rob,
> To solve the problem of error, you can delete this (
> Sheets("List3").Select ), it will not affect the main macro.
>
> Basole
>
14 matches
Mail list logo
