Posts by dodger7

Hi people

Im importing figures into column G of my worksheet, and I need a code so it automatically adds a "0" to the start of each row in column G plus format it.

For example, im pasting in 970702090341 but its showing as 9.70702E+11.

Once I format the cell to 'number' and 0 decimal places it looks fine, but want to save the hassle of doing it each time. Plus I need a zero at the start.

Is there a code possible for this?

Thanks in anticipation
Jamie

Re: Restict Scroll Area Not Saving When Workbook Is Closed

thanks for the replies. Its now working thanks Bruce and Andy

Re: Disable Scroll Not Saving When Sheet Is Closed

Hi,

Ive tried disabling scroll on sheet 1 of my workbook by entering the cell range into the properties window in VBA. However when I save the sheet and reopen it, it seems to reset and are able to scroll again.

I tried using the following:

Private Sub Worksheet_Activate()
Worksheets(1).ScrollArea = "A1:Q51"


End Sub

and a few variations of the above but this dosnt seem to be working. The only other code I have in the workbook is under "thisworkboko" which is this:

Private Sub Workbook_Open()
Application.DisplayFullScreen = True


End Sub

so I dont know why its not working

Any suggestions?

Thanks in advance

Hi,

Ive tried disabling scroll on sheet 1 of my workbook by entering the cell range into the properties window in VBA. However when I save the sheet and reopen it, it seems to reset and are able to scroll again.

I tried using the following:

[vba]Private Sub Worksheet_Activate()
Worksheets(1).ScrollArea = "A1:Q51"

End Sub[/vba]

and a few variations of the above but this dosnt seem to be working. The only other code I have in the workbook is under "thisworkboko" which is this:

[vba]Private Sub Workbook_Open()
Application.DisplayFullScreen = True

End Sub[/vba]

so I dont know why its not working

Any suggestions?

Thanks in advance

Re: Formula For Findind Out A Percentage

thanks for the replies. It turns out my formula wasnt working because when row D was imported it had spaces after the numebrs, so the formula wasnt working!

thanks agian

Hi people

I have in row D a list of numbers and in cell F a list of salaries. I need a forumla to tell me what percentage D1 is of F1 etc.

IE the formula will be something along the lines of D1 * 12 / F1 * 100

cheers peeps

Re: Formatting A Field With Mail Merge

excellent mate, that worked thanks.
I have a new problem now - its appearing bold. Ive tried everything, but it wont go away! any ideas?

Thanks again

Hi

Im doing a mail merge and one of the fields is a numeric value. However once it imports from excel, there is no thousand or million comma seperator (for example its shows 1350245.23 instead of 1,350,245.23)

is there anyway I can format this field to include the comma seperators?

Many Thanks

Re: Chart/Graph x Days From Another Workbooks Data

thats what I was trying but it kept saying reference invalid. I will drop the assumed experience however i never set it at above average, ive never touched it.

Re: Chart/Graph x Days From Another Workbooks Data

thanks. How Do I tell the graph to go to other workbooks for the figures?

Hi

I have a spreadsheet in the office which is completed and saved in a folder daily. Im looking to add a line chart onto the daily spreadsheet which shows the figures from the last 20odd days so that they can be easily compared.

Can this be done?

Many thanks

Re: disabling functions

cheers mate, that will do. Out of curiosity, is it possible to disable the above functions?

Re: disabling functions

but when I do format sheet>hide then click the button on sheet 1 to view the hidden sheet I get a VBA error. Is there a way of viewing the data of a hidden sheet? I didnt thin kther was, thats wht I was trying to use the abvoe method.

thanks again

Re: disabling functions

thanks - however I need some of the tabs viewable just not all them

cheers

Hello

is there any way of disabling the following functions:

adjusting the size of the horizontal scroll bar;
being able to scroll to the right to search for tabs covered by the scroll bar

the reason being I want to have a few sheet tabs hidden but still be able to see the data on the sheet if a button taking you to the sheet is clicked

thanks in advance

Re: Hide some sheet tabs

but if I do that then dosnt that mean i wont be able to see it?

what im looking for is the sheet tab to be hidden but when I click a button to take me to the hidden sheet I can still see the data on the sheet. It might not be possible...thats what i was hoping you guys could tell me.

Re: Hide some sheet tabs

Quote from NathanC

You could use code (on workbook_open or something) which hides the ones you want hidden. Then when the button is clicked it could unhide the sheet and select/activate it. Upon worksheet_deactivate hide it again.

do you have a code for this>

cheers

hi people

ive got a workbook with 13 sheets. I only want 7 of these tabs viewable but still want the sheet to be viewable by clicking on a button i.e you can click a button on the first sheet which takes you to sheet 9 but you cant see the tab for sheet 9 at the bottom of the workbook.

is this possible?

many thanks

Hi Guys,

got a list of 724 rows with info on one sheet, and the same on the other but theres 3 or 4 rows wiehe info is different - whats the best formula to use to compare these to say something like" if A2 = sheet2 A2, 'same, "different"?

cheers

Hi Guys,

I work in an office and I have created a spreadsheet for certain people within the office to use. Is there a way I can save it so that when other people open it at their own PCs it opens full screen (or maximize)?

I dont have access to Marco/VBA in the office

Thanks in advance

JAmie