Apply to Worksheets - Specific Properties in Cell Ranges

**sl729** · 07-04-2016, 11:38 AM

Hi Folks,

I am trying to apply some changes to some worksheets, I have listed it in a worksheet called "WorksheetDesign"

The worksheet names are in column A, the cells that need to be changed are listed in column B

Please Login or Register  to view this content.

I have tried to make some code

Please Login or Register  to view this content.

Some thing is not right - I'm not sure if it's the worksheet name or some other property amiss, there are a lot of things i want to change over time , so i thought a table structure to list everything would be easier

please do let me know
thank you
sl

**Neil_** · 07-04-2016, 04:36 PM

You've never assigned a string to oWksht, so it is always an empty string.
#
By the way, if you are going to use camel case, then the first character usually means something. o usually represents object, but you've defined oWksheet as a string. sWksht or strWksht is easier to understand. us oWB or objWorkBook if you want to indicate to someone reading your code that it is an object.

This is all highly semantic of course and many now argue against hungarian notation altogether.

**Neil_** · 07-04-2016, 04:45 PM

Please Login or Register  to view this content.

Make Worksheets(sWsheet).Font.Size equal 30 or the value in column B. You can't do both.

option 1
Worksheets(sWsheet).Font.Size = 30

option 2
Worksheets(sWsheet).Font.Size = oWsheet.Range("B" & i).Value

**sl729** · 07-04-2016, 05:27 PM

Hi Neil,

you are right - i did not even notice the double equal, just glazed over my eyes in plain sight.

Also i never new the o was used for object - i just thought that's how you labeled them

I'm not having much luck fixing this let me try again
thank you
sl

Apply to Worksheets - Specific Properties in Cell Ranges

LinkBack

Thread Tools

Rate This Thread

Display

Apply to Worksheets - Specific Properties in Cell Ranges

Re: Apply to Worksheets - Specific Properties in Cell Ranges

Re: Apply to Worksheets - Specific Properties in Cell Ranges

Re: Apply to Worksheets - Specific Properties in Cell Ranges

Thread Information

Users Browsing this Thread

Similar Threads

SUMPRODUCT Formula for Inventory of Properties in specific states & date ranges.

[SOLVED] Apply Macro to specific worksheets in workbook

setting cell properties with a range of worksheets

[SOLVED] Combining specific ranges from multiple worksheets into one

[SOLVED] Combining specific ranges from multiple worksheets into one

Combining specific ranges from multiple worksheets into one

[SOLVED] Combining specific ranges from multiple worksheets into one

Bookmarks

Bookmarks

Posting Permissions