PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. [SOLVED:] Count the number of cells in a row that are not empty
  2. [SOLVED:] Saving as .csv
  3. [SOLVED:] Problem with "ReDim Preserve"
  4. [SOLVED:] Count how many cells have been merged to make one cell.
  5. Sleeper: Page footer: page one of x, sub page 1 of 2
  6. [SOLVED:] Arrange sheet names in sequence
  7. [SOLVED:] Overflow error 6
  8. [SOLVED:] Remove Macros from a workbook with VBA
  9. [SOLVED:] VBA Code Library (this site)
  10. [SOLVED:] Add new record in spreadsheet
  11. [SOLVED:] Hyperlink on sheet 1 to sheet 2 in same workbook?
  12. [SOLVED:] Can you hyperlink to a hidden sheet?
  13. Sleeper: Excel-Outlook-Access Link
  14. [SOLVED:] Summarize data. VBA CODE
  15. [SOLVED:] A harder Hyperlink question.
  16. [SOLVED:] Excel **
  17. Sleeper: How to create a sort instruction
  18. [SOLVED:] open notepad, select all, copy, paste in excel
  19. Solved: write cell address in text file through vba
  20. Sleeper: Copy a range of cells in a for loop
  21. Sleeper: Get server name
  22. Sleeper: Shuffling Data onto a new Worksheet
  23. [SOLVED:] John Walkenbach's FaceIDs Display
  24. [SOLVED:] Delete all non-matching sheet names
  25. Solved: display progress bar
  26. [SOLVED:] Get sheets name
  27. Sleeper: Detect and change column width
  28. Sleeper: Help with optimizing formulas and workarounds...
  29. [SOLVED:] How to NOT Plot a Cell with Formula = Blank
  30. [SOLVED:] Problem Formatting Date for Display
  31. Sleeper: Could not find installable ISAM
  32. [SOLVED:] Another sumif - sumproduct delima
  33. [SOLVED:] Shared workbook
  34. GetOpenFilename multiselect
  35. [SOLVED:] Cant determine a cells contents
  36. [SOLVED:] Select given month in various years
  37. Sleeper: The difference between Hidden and VeryHidden
  38. Sleeper: Read-Only ... Shared Access ... etc Problem
  39. [SOLVED:] Total in user form
  40. [SOLVED:] Populating csv. file with text values
  41. [SOLVED:] Adding a Column Total to a Printed Report
  42. [SOLVED:] Copying cells when switching to excel
  43. [SOLVED:] Transposing Data
  44. [SOLVED:] Comparing text to cells but only partial match
  45. [SOLVED:] Multidimensional Array Initialization
  46. sort and create new sheets from CSV data
  47. [SOLVED:] Clear contents of cells
  48. Sleeper: Select and delete
  49. [SOLVED:] Hiding Rows with a special column? (Please see attached.)
  50. [SOLVED:] Border around a range of cells
  51. Sleeper: Converting Hrs:Mins to general/currency value
  52. Sleeper: Move Cursor Of Second Sheet As Per The First Sheet
  53. [SOLVED:] Problem with simple loop!
  54. Sleeper: Launching xls via shortcut duplicates macro prompt
  55. [SOLVED:] Header
  56. Sleeper: Auto formatting
  57. Sleeper: Dates and times
  58. [SOLVED:] Help combine workbooks into 1
  59. Sleeper: Simple Hyperlink Question
  60. A (fiendly) Challenge to brettdj
  61. [SOLVED:] Click AutoShape and close the workbook w/ option to save.
  62. [SOLVED:] Chart Limitations (Plotting from Arrays)
  63. [SOLVED:] Insert VBA code in new Workbook via VBA
  64. [SOLVED:] Macro for Find & Replace
  65. [SOLVED:] Is there a way to retrieve the product key.
  66. Sleeper: Making this code more dynamic
  67. [SOLVED:] Remove any formatting from cells
  68. [SOLVED:] Interior.ColorIndex
  69. [SOLVED:] Is there a Scroll Event?
  70. [SOLVED:] Clearing Cond. Fmts from a Range
  71. Sleeper: Excel formula
  72. [SOLVED:] Can VBA Statements Be Stacked?
  73. [SOLVED:] UDF's
  74. Solved: cell formatting row wise
  75. [SOLVED:] Check if the text is ALL UpperCase (UCase)
  76. [SOLVED:] Concantonate Cells
  77. [SOLVED:] Selection.Font.Bold
  78. [SOLVED:] Keyboard shortcut to skip through sheets in a open MS Excel workbook
  79. [SOLVED:] Find everything to left of ":"
  80. [SOLVED:] Open path given in txtbox1
  81. [SOLVED:] Conditionally Color Drop-down Choices
  82. Solved: Defined Name Errors...Please Interpret
  83. [SOLVED:] Can't Create New Sheet by "Running" Macro
  84. [SOLVED:] Determing Array Size
  85. Sleeper: Loop through range to copy/paste hyperlink
  86. [SOLVED:] Test cells for scientific formatting
  87. Sleeper: Opening Template
  88. [SOLVED:] Check sheet names and display MsgBox
  89. [SOLVED:] Select - deselect chkboxes
  90. [SOLVED:] Help with case statement
  91. Sleeper: Pivot table naming causing error
  92. Sleeper: Excel bombs out when I try and Save the workbook
  93. [SOLVED:] colour From LEFT to RIGHT of a cell starting from where a COLON is found
  94. [SOLVED:] VBA Like statement
  95. Sleeper: Unable to focus on another sheet
  96. [SOLVED:] Need Help with a Change Event
  97. Sleeper: Format summary lines
  98. [SOLVED:] Worksheet VBA naming
  99. [SOLVED:] need help with VB script, error on cancel..
  100. [SOLVED:] How to link to a file one folder up.
  101. Sleeper: Printing to PDF
  102. [SOLVED:] Clear cells based on length of cell
  103. [SOLVED:] Data Validation List
  104. Sleeper: Transfer to a Different Macro When Stepping Thru Execution
  105. External Data Help
  106. [SOLVED:] Font.Size
  107. [SOLVED:] Add to a stock symbol
  108. [SOLVED:] Help finding the last cell in a range.
  109. Sleeper: Help with copy import script
  110. [SOLVED:] VBA: Put Day in Footer/Header
  111. [SOLVED:] Forcing Hyperlinks to Open in a new Window
  112. [SOLVED:] Lock Column or Rows (Editing restriction)
  113. Sleeper: Can not open excel ss
  114. [SOLVED:] Macro sends sheets to printer in ascending order, but they're not printed so.
  115. [SOLVED:] am I doing this right ? del sheet if there, else...
  116. [SOLVED:] Passing Variables through sheets
  117. [SOLVED:] Checking Checkbox values
  118. [SOLVED:] Subtotals
  119. [SOLVED:] Home key action
  120. Sleeper: Security issue
  121. [SOLVED:] Help linking page
  122. [SOLVED:] Why is this text and not number?
  123. [SOLVED:] DatePart (Format Standard Date Time)
  124. Sleeper: The sound played upon displaying a msgbox
  125. Check for Blank Cells in Column
  126. [SOLVED:] Progress Bar / Status Bar
  127. [SOLVED:] Populate ListBox from Excel Column
  128. [SOLVED:] On error behaviour
  129. [SOLVED:] Range Dynamic Query
  130. [SOLVED:] find a string
  131. Sleeper: Trigger event when rows are inserted or deleted
  132. [SOLVED:] Print Macro
  133. Sleeper: Using TextBoxes for Numbers
  134. [SOLVED:] Sort Alphabetically List Box
  135. Sleeper: Multiple Value List Box
  136. [SOLVED:] Long Loop Time
  137. Sleeper: Close Workbook and via Close Excel
  138. Sleeper: Dependent lists in order to restrict choices
  139. [SOLVED:] Pass value to sub in .xla
  140. Sleeper: Print Log
  141. [SOLVED:] Help with Lookup
  142. Sleeper: Getting one cell to stay on top of all sheets
  143. [SOLVED:] Array Function?
  144. Sleeper: Easy Cell Reference - "Guide" Lines
  145. Sleeper: Multiple Charts with dynamic ranges
  146. Sleeper: Filter ListBox Items
  147. Sleeper: Input Box asks for input twice!
  148. Sleeper: Look right until there are no more cells with content
  149. Sleeper: Search string 2
  150. [SOLVED:] Boolean true
  151. Sleeper: Clean and speed up code.
  152. [SOLVED:] Document workbook Properties
  153. Sleeper: Insert Object
  154. [SOLVED:] Send Link?
  155. [SOLVED:] VBA Naming Convention; Parameter; ByVal & ByRef;
  156. Sleeper: Word object in Excel
  157. Sleeper: Copy and paste
  158. [SOLVED:] The equivalent for CInt for creating a long
  159. [SOLVED:] Using Lookup command I think
  160. Solved: Conditional Formatting
  161. Sleeper: Accessing an Excel Module
  162. Sleeper: Sort worksheet by suffix
  163. [SOLVED:] How to install Calendar Control 11.0
  164. Sleeper: User defined range and sheet
  165. [SOLVED:] How to force the user to make entry(ies) in a specific worksheet before continuing?
  166. [SOLVED:] Get all sheet names in comboBox of activeworkbook and export when selected
  167. [SOLVED:] Automatic launch of a MsgBox
  168. Sleeper: Print to different printer based on cell value
  169. [SOLVED:] Adding Time written with Text
  170. [SOLVED:] Formatting MsgBox
  171. [SOLVED:] Problem with "On Error" Not Trapping
  172. [SOLVED:] How to insert rows based on different values
  173. [SOLVED:] How to cut one sheet's values and paste it in other sheet?
  174. Sleeper: Function defintion in comment
  175. [SOLVED:] Need help with date manipulation
  176. Sleeper: Sorting sheets by month from different workbooks into one
  177. [SOLVED:] Convert Decimal To Binary
  178. Sleeper: Adjustment to Hyperlink KB Code
  179. Sleeper: TicTacToe Smarts
  180. [SOLVED:] Chk sheet names of 2 wrkbk & delete if not matching
  181. Sleeper: Help with macro please
  182. [SOLVED:] Copy from multiple sheets paste to new Sheet
  183. [SOLVED:] Tab Column in VBA Form
  184. [SOLVED:] selecting cells
  185. Sleeper: Pivot table summarizing by sum
  186. Sleeper: Display correct toolbar icon on starting excel application program
  187. Sleeper: Using vba variable to create data series for pi and bar graphs
  188. [SOLVED:] CD-ROM - List File Attributes of Directory and Subdirectores (like brettdj's KB)
  189. [SOLVED:] Opening Text files
  190. [SOLVED:] Decimal Type ?
  191. [SOLVED:] Sorting macro
  192. [SOLVED:] Advanced Filter Criteria Non Adjacent Cells
  193. Sleeper: Checking that a document in Word was printed from Excel?
  194. [SOLVED:] Program to Identify duplicate entries
  195. [SOLVED:] Compile error: vba VIA vba
  196. [SOLVED:] Combobox help
  197. [SOLVED:] Application.ScreenUpdating
  198. Sleeper: File opens as read only
  199. [SOLVED:] Compare 2 sheets different sizes
  200. Sleeper: Problem in coding
  201. Sleeper: Copy all sheets (filter some rows)
  202. Sleeper: Open web browser with specific address
  203. Sleeper: Add unprotected rows to protected sheet
  204. Sleeper: Conditional formats to make things easier on the eye
  205. [SOLVED:] Question About the "Resume" Statement
  206. Sleeper: Copy all files in a directory
  207. [SOLVED:] Run Outlook from Excel
  208. Sleeper: Dynamically write data in cell
  209. [SOLVED:] How to do sorting by values?
  210. Solved: Placing cursor in a specific textbox when form opens
  211. [SOLVED:] Pivot table (data range).
  212. Sleeper: Clear cell ranges if reference cell changes
  213. [SLEEPER:] Adding a sheet
  214. [SOLVED:] Automatically rearrange columns
  215. Sleeper: Conditional rows deleting
  216. [SOLVED:] Crazy Request
  217. [SOLVED:] Enable CTRL+HOME, CTRL+END
  218. [SOLVED:] Pitfalls of Earlier versions of Excel
  219. [SOLVED:] Change Font of UserForm1
  220. [SOLVED:] Cell formating
  221. [SOLVED:] Output GUI Components' Names of Form
  222. [SOLVED:] Call Function
  223. [SOLVED:] Assign Macro to Button on Spreadsheet
  224. [SOLVED:] Grid Box
  225. [SOLVED:] Rounding up question
  226. [SOLVED:] A Looping Question
  227. Sleeper: Macro's and Dates
  228. [SOLVED:] A loop question & write texts
  229. [SOLVED:] Eliminating blinking cursor in UserForm Text box
  230. [SOLVED:] Differrences between Rnd and Randomize
  231. [SOLVED:] my firefiter
  232. [SOLVED:] Finding selected optionbutton on a userform
  233. Sleeper: Enter Data In Worksheet & Delete Empty Rows
  234. Sleeper: How could I fill automatically a column using VBA?
  235. [SOLVED:] Validation bugbears
  236. [SOLVED:] Unprotect cell
  237. Sleeper: Copy columns to new sheets
  238. Copy data from one file to another in Excel
  239. [SOLVED:] Mapping old to new with VBA
  240. [SOLVED:] Formula wont copy down correctly
  241. [SOLVED:] Print all sheets
  242. [SOLVED:] List Box - Row Source
  243. Sleeper: Sub & Function
  244. [SOLVED:] Read Each Row Output Text File
  245. [SOLVED:] Clear Cells Except First Row
  246. [SOLVED:] Activating a pop up calendar by clicking in a cell
  247. [SOLVED:] Two Dynamic Named Range Copy/Paste
  248. [SOLVED:] What's with this "Run time Error 1004?"
  249. [SOLVED:] About Subtract Function
  250. [SOLVED:] Auto open folder and click button help