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

  1. Solved: Changing the settings of a combobox
  2. Solved: Highlight cell from link
  3. Solved: Move rows to new sheet based on condition
  4. Solved: Emailing CC. recipients
  5. Solved: Sort Data and color code
  6. Solved: Inserting Rows after a count
  7. Solved: lookup the 4th characters in a cell
  8. Solved: Sinple question regarding calculating a due date...
  9. Identify the numbers that make up the average
  10. Generating an incremented workbook file & save as variable
  11. Solved: Digital clock within worksheet needed
  12. Solved: delete open workbook
  13. Regex in Excel 2007
  14. export worksheet problem
  15. Solved: VBA code for "or" + "and" functions
  16. Solved: Dynamically hide unused rows
  17. Solved: Open vba file
  18. Solved: Append matched row data from source wsheet back to corresponding row
  19. Enter, Tab and Up/Down Arrows Stop Working
  20. Does visual basic express work with excel?
  21. Downloading data from webpage into Excel
  22. copy values that aren't zero
  23. Solved: Filter & Transfer
  24. Solved: Delete Sheet list
  25. Solved: Get FileNames From Folder Not Using PathName
  26. Solved: Best way to go about?
  27. Solved: Copy a range from the fourth sheet on
  28. Transpose Question
  29. Solved: Minimum Positive value finder using VBA
  30. How can I make CopyPicture show the selected cell
  31. Solved: add leading zeros with a specified length of characters
  32. Solved: Finding the hour prior to original hour
  33. Summary sheet update keeping set columns in place
  34. Solved: search value and insert row under value
  35. From Excel Find Replace in Word 2
  36. Temporarily widen column
  37. help with print, clear and save maros
  38. Solved: Problem with formats
  39. Solved: Add to existing IF formula
  40. Change Drive Letter of Removable Storage
  41. Solved: Charting with labels
  42. Solved: Stumped - formulas required
  43. Copy adjacent cells and paste in non adjacent columns
  44. Solved: Function with multiple exit points
  45. Solved: Major issue blank cells
  46. Solved: VBA for Cell Link to network folder document.
  47. Solved: Excel Macro Not Setting a Cell's Value
  48. Multi Users in Excel
  49. Solved: Loop Until Blank or situation
  50. conditional formatting help
  51. Sorting a range of cells
  52. Delete Empty Sheets
  53. Solved: add headers to print then set page setup settings back.
  54. Replace Combobox with Listbox ...
  55. Solved: Copying between sheets
  56. Solved: checkBox-- Handle Value
  57. Solved: Exclude rows
  58. Solved: Copy specific cell based on date condition paste to specific cell
  59. Is it possible to loop a macro constantly?
  60. copy rows from worksheet 1 to worksheet 2
  61. Solved: Delete any spaces in cell
  62. Macro to copy, then paste to visible cells
  63. Solved: Copying data onto next empty row, under certain criteria
  64. Determining how a ComboBox was changed ...
  65. Using VB 08 to combine excel files
  66. Solved: SOLVED -- Update cells same sheet based on data changes
  67. Solved: Highlight ROW based on cell value
  68. Selecting a group of cells using the Range.offset syntax
  69. Solved: Printing a *.gif file from a command button depending a cell value
  70. Solved: Userforms created with macro
  71. Solved: Automation error
  72. Solved: Countif formula to be used on a dynamic range to be used on a data table
  73. Sum dynamic number of worksheets into one
  74. Solved: Cut entire rows to sheet on condition
  75. Solved: VBA Date Formatting with links
  76. Enter image based on cell value
  77. Solved: How to find the most common numbers?
  78. Solved: FSO Function to get Datelastmodified, DateLastAccessed
  79. Get sub group data based on main group
  80. Solved: MsgBox code to check for Existence of and Opened Files
  81. Solved: Autocomplete cells
  82. Solved: need help to create a "database" in excell
  83. Number of sorts allowed in XL2007
  84. Help Needed, E-mailing reports
  85. Solved: IsFileOpen and WorkbookIsOpen giving differing results
  86. Pivot Table data source
  87. Solved: Number Format from access field into excel
  88. Loop through chart and Highlight chart labels based on value
  89. Find number of lines ?
  90. Change to Month Sheet name
  91. Solved: User Defined Function Question
  92. Solved: URL -No Highlight Search Results.
  93. data validation from an add-in
  94. Problem adding References to Excel VBA App
  95. Autofilter Help
  96. Solved: Problem counting decimal places
  97. percentages and comparing two values whats the best way?
  98. Sequential Cell Numbering
  99. Database Question
  100. Solved: Rank Function Question
  101. Delete all characters after a set number in a cell
  102. find the closest date
  103. Insert sheet
  104. Urgent help Needed <<removing Rows
  105. Solved: Refresh data upon open
  106. Solved: Single member array problem
  107. Combining Project Timesheet Help
  108. Solved: Unprotect Sheets while looping through files
  109. Solved: Unorganized Summing
  110. select A2 through the last used cell in a column
  111. Interrupting a macro
  112. Copy Filenames from Folder
  113. Copy number of rows to formula result
  114. DPercentile
  115. Advanced Filter and Unique Count Code
  116. Using VBA to LOOKUP
  117. Simple VBA-code question
  118. basic unique refs loop
  119. VBA Copy based on offset
  120. Solved: Conditional Formatting Based on Percentage
  121. vlookup help
  122. How do I copy and paste cells that contain "@ml.com"
  123. Solved: Get absolute address for hyperlinks
  124. If statement not working
  125. Convert row into multiple rows of data (ARRAYS)
  126. Solved: Code to Move to next sheet
  127. Solved: Deleteing indertiminate spaces
  128. how to hide all menus from excel woorkbook?
  129. Solved: Excel Freezing every 30 seconds
  130. Solved: Show custom error message if file already opened by someone else
  131. Color Code row based on cell content
  132. Solved: Referencing a named range for a UserForm?
  133. Solved: Finding Last column in Row
  134. Select Case & Data Validation Issues
  135. Transferring data from two dimensional VBA array to Excel range -
  136. A different Change event
  137. Solved: Autofill Cells
  138. Solved: Inserting &amp; Naming New Columns in Multiple Worksheets
  139. got error 1004 when executing this code
  140. Runtime Error - Email Code
  141. Selecting sheets in add-in
  142. FInd Problems
  143. Solved: Deleting Empty Rows
  144. Solved: Cut and Paste macro
  145. SaveAs script
  146. Solved: INDIRECT OR INDEX OR WHAT? I'M LOST
  147. Solved: Strange Excel Error
  148. Solved: Set FollowHyperlink default Web browser
  149. VBA Excel and IE login info "Not Sharing"
  150. bind ListObject to Recordset?
  151. Solved: Pivot Table Update Data Source
  152. Solved: Run code on cell selection
  153. Solved: WorkSheet range Activate issue
  154. Excel form - listbox
  155. WinHttpRequest with HTTPS
  156. Solved: How do I create a range based on a column name?
  157. Click OK on a dialogue popup box
  158. Solved: matching that finds the greatest/least amount
  159. Solved: Test if an item exists within a collection data type
  160. Solved: Links to other data sources.
  161. Flash the TaskBar
  162. Code for detecting when a Msg box opens
  163. Solved: Convert row into multiple rows of data (ARRAYS)
  164. Solved: Code for printing.
  165. using (iserror) in if statement
  166. Solved: Repeat Column Insertation (It's simple!)
  167. trailing zeroes
  168. Sum for sub total and grand total
  169. Solved: Excel in Parallels Word not... Help
  170. create report for list of numbers
  171. Solved: Stop excel from calculating
  172. For Each-Next code tidying up
  173. Solved: If a condition is True how to add a number
  174. Solved: Blank cells
  175. Clearing my autofilter
  176. For Input as #1 Question
  177. Solved: AutoFilter macro issues
  178. Polygon's
  179. Solved: backgroundquery:=false seems to fail
  180. Adjusting macro from L.Notes to Outlook
  181. Copy Excel Range Into Outlook Email As Bitmap?
  182. Referencing Other Open Workbooks.
  183. Duplicate names for same range
  184. VBA : Populate list
  185. Solved: VBA for &quot;IF&quot; function
  186. Solved: Handling large ranges
  187. Solved: Replicating changes to one WS to others
  188. Excel Map gets destroyed when opened
  189. Solved: Transpose selected cells and place result on other sheet
  190. Confused about RefersTo
  191. Solved: IF CASE
  192. List population dependent on another cell
  193. hlookup and vlookup
  194. Workbook_Open Does Not Work
  195. Solved: Create History
  196. Need Help W/Sort
  197. Solved: Help using For loop in a IF then statement
  198. referencing of cells shows formula not values
  199. Solved: SOme one help find out what is happening
  200. VLOOKUP MACRO NOT WORKING PROPERLY
  201. Option Buttons
  202. "yyyymmdd_hhmm" change to Date, Time format
  203. need a code.....
  204. Solved: Display items of a collection in a message box?
  205. Solved: Inrease a number in a column basd on condition
  206. Macros in personal.xls execution based on different file names
  207. X-Y scatter graph refering a series of data log
  208. How to retrieve DataSource of chart
  209. macro to delete files - three days later
  210. Complex workbook_open solution needed
  211. Solved: Row to hide on drop down selection
  212. chasing ranges that move
  213. Ignore Hidden Sheets in vlookup macro
  214. Solved: Worksheets name
  215. Transfer items from list to textbox
  216. Solved: Create a rolling reference number
  217. Solved: macro for every cell on the sheet
  218. Solved: Counting number of pages in word
  219. Solved: file name extensions
  220. Solved: Email through Outlook contacts
  221. help with: suming only colour filled cells in a column
  222. Solved: Big Automation Question with Pivot Tables and Graphs
  223. Solved: VBA strangeness, need help please
  224. Solved: Listbox with data from other sheet problem
  225. VBA help - Vlookup
  226. Solved: Button to insert row in multiple worksheets and update
  227. Solved: ComboBox won't respond to repeat of previous selection
  228. Solved: Cmd Button Caption
  229. Solved: data validation question
  230. Solved: Find String and Merge Cells
  231. Solved: Disable Cmd Button
  232. Solved: Performing a task in vba if time is between 2 times?
  233. Solved: Limit Entries
  234. Open and refresh
  235. Autofilling a formulae to lastrow
  236. Sub reference as Cell
  237. Solved: XLD - Chart Help
  238. Saving a screen capture ~ PrintScreen (Excel '97)
  239. Help W/Small Code . .
  240. Help with Function
  241. Check Box Click()
  242. Copy Workbook, Saveas NewFile, Edit NewFile
  243. Help W/UserForm
  244. Funtions: For non-english Excel users
  245. Solved: Make NewWebQuery with URL-variable.
  246. exporting excel charts to Word
  247. Solved: extract a column to 5 column
  248. Loading Reference aborts Sub
  249. Solved: listbox little bug
  250. VBA Splitting the text 1-8 to (1,2,3,4,5,6,7,8)